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
678 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

914 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

18 Experts available now in Live!

Get 1:1 Help Now