SAP Knowledge Base Article - Public

1278232 - Removing blank lines from a report

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

Crystal Reports 2008 V0 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2

Attachments

CR_multi-pass.JPG