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
681 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

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
 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

733 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