Extra blank page in exported MS Excel file
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:
- 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.
- Sub Report >> Section Expert >> Group Footer #2 >> Common Tab >> "Keep Together" is not checked
- 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.