Crystal Reports - Hide Footer based on Criteria
Posted on 2014-01-28
I am using Crystal Reports XI R2 and MS-SQL 2008
I have information in a Sub Report that I would like to pass back a variable to either suppress or display a group footer.
If I save the value to a variable, the value is only populated on the next group, so the current footer is not able to evaluate the correct variable.
I have created a Group Footer 1a and 1b so that it displays in 1b, but I am unable to hide 1a.
The reason for running a sub report is that I need to evaluate information from another Database which selects its information based on Data passed from the main report.
The Answer would be to run a SQL Expression Query, but there does not seem to be a way to pass variables or selection information to a SQL Expression