Skip to Content
0
Oct 21, 2015 at 02:45 PM

Extra blank page in exported MS Excel file

200 Views

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

Attachments

1.jpg (109.2 kB)
2.jpg (72.9 kB)