Skip to Content

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

Extra blank page in exported MS Excel file

Hi there,

We have a report file which has Main report and one Sub report. And we want to insert a page break per Sub Account Type in subreport.

This is the current settings:

  1. Sub Report >> Section Expert >> Group Header #2 >> Paging tab >> New Page Before >> Formula Workshop >> Added a formula "Not OnFirstRecord" but  "New Page Before" option is not ticked.
  2. Sub Report >> Section Expert >> Group Footer #2 >> Common Tab >> "Keep Together" is not checked
  3. Main Report >> Right Click on Sub Report >> Format Subreport >> Sub Report >> "Supress Blank Subreport" is checked >> we unchecked this option but both did not work..

We want a page break in Group Header #2 level but not a empty page.. Currently row 26 is generated as a blank page as below screenshot.

Could anyone help us for this issue? Users are losing their patience and we need to fix this problem asap.

Thank you in advance.

Appendix 1:

Appendix 2:

Chrissa

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