Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Where / how to place a suppressed sub-report without extra blank lines

Hello, we are having an issue which populate extra blank lines in print preview and exported MS Excel file. We are using Crystal Report 2011.

The report contains one sub-report which has a calculation field (in red square in the below screenshot) in Group Footer #1a, and it is used in the Schedule Payment field (in blue square in the below screenshot) in Group Footer #1b. The field in the sub-report is suppressed and used for just calculation.

We tried to move the sub-report in from Group Footer #1a to Group Footer #1b. However, the value of Scheduled Payment in Group Footer #1b became wrong. If we keep the sub-report in Group Footer #1a, the Scheduled Payment value is correct but Group Footer #1a is printed as blank line which we would like to remove/hide.

We also tried to change the font size of Sub-report to Font 1 and set the height 0.001. However, when we saved and closed the report, and re-open it, the height became 0.042 (we assume this value is the minimum height of object) and still generate extra blank line.

-->

Is there any other way to get rid of the blank rows and with keeping the correct value? Please advise.

Thank you in advance,

Christine.

replied

Hi Abhilash,

Since we could not find any solution, we ended up moving the query in subreport in stored procedure and providing the values to the main report.

Thank you again.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question