on 10-21-2015 3:45 PM
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:
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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:
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.
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.
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.
Hi Chrissa,
Could you also post a screenshot of the report's Design page?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.