Hi Brian,
I'm not sure I understand...this is one of my formulas, it is using Basic Syntax:
Dim Parameter
Parameter = "Start Date: " + ToText({?@StartDate},"M/d/yyyy") + " " + "End Date: " + ToText({?@EndDate},"M/d/yyyy") + " " + "Case Type: " + {spRpt_WeeklyInventoryDetail;1.CaseType} + " "
if ISNULL({?@InsCarrierID}) = False Then
Parameter = Parameter + "LOB: " + {spRpt_WeeklyInventoryDetail;1.InsCarrier} + " "
End IF
if ISNULL({?@CaseStatusID}) = False Then
Parameter = Parameter + "CaseStatus: " + {spRpt_WeeklyInventoryDetail;1.CaseStatus} + " "
End IF
Formula = Parameter
The same basic formula works in other reports, so I'm not sure where I should put single quotes?
Also, I was trying to suppress Group Header fields using this (Crystal)syntax:
{spRpt_WeeklyInventoryDetail;1.CaseStatus} = "Closed"
Again, I've used both of these types of formulas in other reports. And, if I remove all of these formulas, I still get invalid group condition.
Thanks again for the help
IP Logged
