Symptom
I'm trying to remove the blank lines from the enclosed report. I know the blank lines are coming from the subreport, but I can't
find a way to remove them.
Cause
Evaluation passes in Crystal Reports entails creating the grouping first which includes underlay following sections option.
Conditional suppression of other visible section includes print time formulas which are evaluated last.
This results in the underlayed section containing the sub-report is constant so that it shows blank space when the lower section being conditionally suppressed only occurs intermittently thus causing the blank spaces between data rows.
Resolution
1 - Create a stored procedure to include the calculations to pull only the data required to be shown in the report.
2 - Create the report using the stored procedure as the data source.
Keywords
KBA , BI-OD-CR , CrystalReports.com , Problem
Product
Attachments
CR_multi-pass.JPG |