Extra blank page in exported MS Excel file

[former_member533461]

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

[DellSC · Accepted solution]

Chrissa,

It looks like you're doing the Excel (97-2003) export that includes all of the formatting.  When you export to this format, there should be some additional format options in Crystal.  In particular, make sure that "Create page breaks for each page" is turned off.  If that does not solve your problem, then there is no way to solve it using this export type.  The export is creating the single tall row to take up the rest of the height of the page.  Unfortunately, there is no way to control this from Crystal.  This is the way that it has been since I've been using Crystal (@19 years).

You could try exporting to Excel Data Only and turning on "Export object formatting" to see whether that will get you what you need.  You'll probably have to play with the "Export page header and footer" and "Simplify page headers" settings.

-Dell

[former_member533461 · Accepted solution]

Hi Dell,

Thank you for your professional advice. Yes, we are exporting with all the formatting into Excel. I just double checked "Create page breaks for each page" is not checked, so this is crossed out as a root cause..

I attempted to export to Excel Data Only with provided options but our end users needs all the format rather than simple formatting. We will play around with the report and keep trying to solve this issue. Thank you again.

[julie_jamieson2]

Try using suppress blank sub report, and also suppress blank section on the section containing the sub report ?

It seems to be inserting one row, but a very large row, which is odd.

If you remove the page break from the sub-report, does that remove the large empty space?

[former_member533461]

Hi Julie,

Thank you for your advice.

The "suppress blank sub report" option is already ticked and just tried supressing the blank section (Group Footer #2d) in the sub report. But the issue is not solved..

It is a very large row which is making our client annoyed. And yes, when the below option is unticked, the blank row is not shown.

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.

[julie_jamieson2]

What happens if you export just the subreport to excel?  Have you tried suppressing group footer 2d in subreport?

[former_member533461]

Hi Julie,

Thank you for your advice. When we exported just the subreport to excel, the blank page was generated. Only when the report is exported from the main report, this issue happens.

Also, we have tried to suppress Group Footer #2d and it did not work..

[julie_jamieson2]

Have you tied using New page after on the group footer record instead of new page before on group header?

[former_member533461]

Hi Julie,

We just changed to having New page after on Group Footer #2 in the subreport with Not onLastRecord but the exported Excel file still contains the blank page..

[julie_jamieson2]

Hi Chrissa,

It seems this is by design? The large row is what pushes the data onto the next page for printing?

Edit the sub report & set the export options for that section, otherwise try eliminating the sub report page break & limiting them to the main report by changing the design if possible

Check this link to see if you can find anything useful:

Exporting to Microsoft Excel | SCN

[Former Member]

Where do you place your Sub Report in Main Report (i.e. Group Header, Footer..etc ).

What i noticed from the screen shot you provided is - you are having that issues at end of the Group 1 and Before starting Group 2, and can you please try to see, do you have any formula or any things On group footer 1 or group header 2, that makes this space?

If Not, can you please suppress the Sub-report and run the main report to see if you are still getting this issue?

You would be able to see an issue.

If not,

Please post what you did and what was the result, that will help to understand more.

[former_member533461]

Hi Julie,

Thanks for providing the design guide. We have already looked through the document and followed each steps.

Page break is inserted below Group Footer #2c but nothing in the sub-report is exceeded by design.

Also, [Report Export Options] is grayed out in the sub-report..

We can unlikely change this report design, so I will check what your advised me one by one once again.

[former_member533461]

Hi Chandresh,

Thank you for your response.

We have this sub-report in Group Footer #1b in the main report. We have some other report have sub-report in Group Footer #1 or #2 and they do not have this problem..

There is one formula under Page tab "Not OnFirstRecord" with the group header 2 in the sub-report but nothing else. When we exported only sub-report in MS Excel, this issue does not happen, so we assume that something is wrong with sub-report setting in the main report.

As per what steps we tried, please refer to the above comments. I believe I mentioned everything we tried. Thank you.

[abhilash_kumar]

Hi Chrissa,

Could you also post a screenshot of the report's Design page?

-Abhilash

[former_member533461]

Hi Abhilash,

Thank you for your quick response.

Here are the screenshot of main report and subreport in design page.

Please note that I needed to hide some field and group names  since the report contains confidential information.

Main Report:

Sub Report: