Solved

Prevent extra page at end of Document and ensure All Main report GF are at bottom of page

Posted on 2013-12-17
10
677 Views
Last Modified: 2014-01-06
Hi Experts...

I have several GF in my report...The last GF in report contains a subreport...that utilizes conditional suppression...

My problem is that there is an extra blank last page at the end of the document and I want all GFa - GFh except to be at the bottom of Main Document and GFi to print without an extra blank page, after the GFh.

The document prints fine except when the subreport is fired...when this happens the GFh appears halfway up on the Mainreport when it clearly states 'at the bottom of report'.
PickingTicket-system---Sor.rpt
0
Comment
Question by:Mikeyman_01
  • 5
  • 5
10 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39725753
Is the subreport blank or suppressed for that record?

You have the subreport formatted to kee together.  That may be causing the print at bottom of page to be ignored.  Crystal doesn't know the subreport won't fit until Gh is printed and the subreport is built.

To eliminate the blank page at the end try using NEW PAGE BEFORE on GH1 with the formula
NOT OnFirstRecord

mlmcc
0
 

Author Comment

by:Mikeyman_01
ID: 39726388
Yes I do not want the subreport to show based on the suppression indicated. .which appears to be working...its the GFh record that appears to float when it the subreport appears...when you say NEW PAGE BEFORE. .is this on Main Report?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39726568
Yes.  Right now you have the NEW PAGE AFTER set on the last GF section.  That is causing the extra page unless the subreport thinks it has more to print when it really doesn't.

mlmcc
0
 

Author Comment

by:Mikeyman_01
ID: 39726643
I have changed what you suggested...When the subreport is showing, the GF's from the Main Report are not at the bottom of the page, but rather the top of the next page, then the next page is the SubReport...then there is a Blank Last page...
0
 

Author Comment

by:Mikeyman_01
ID: 39727161
I have added another subreport in the GF...I have enclosed it..

All I want is each subreport to show at the top of the Next page after the last GF without a subreport .

The Sections that do not have a subreport need to print at the bottom of the Main Report..

GFi and GFj are where the subreports are being contained and are conditionally suppressed One will show while the other does not...
PickingTicket-system---Sor.rpt
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 100

Expert Comment

by:mlmcc
ID: 39727294
The problem is it is trying to print the entire group footer at the bottom/end of the page.  Since there are group footer sections left it tries to leave room for them but they are then put on the next page.

This may be a losing battle.

If you suppress or eliminate the sections with the subreports do the group footers behave correctly?

Are you looking at this on the screen or actually printing?

mlmcc
0
 

Author Comment

by:Mikeyman_01
ID: 39727432
If I remove the subreports.. on the last page the GF's appear by themselves on the last page...

If I can get the both subreports to start printing on the top of the pages, and have the GF from the Main Report appear on the Report on the page BEFORE these subreports, this will work...

Can you help me with this??
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39727646
Use the NEW PAGE BEFORE on the sections with the subreports.

mlmcc
0
 

Author Comment

by:Mikeyman_01
ID: 39727756
The 2nd subreport prints at the bottom of the second page...Should I remove any other page related information in the Section area??
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39727997
I would only because it tends to cause problems

mlmcc
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Crystal Report Error 14 59
Crystal Report 2008 script 4 45
Formatting a Crystal Report 2 38
Crystal Reports get subgroup count 1 22
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now