Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 686
  • Last Modified:

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

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
Mikeyman_01
Asked:
Mikeyman_01
  • 5
  • 5
1 Solution
 
mlmccCommented:
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
 
Mikeyman_01Author Commented:
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
 
mlmccCommented:
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
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

 
Mikeyman_01Author Commented:
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
 
Mikeyman_01Author Commented:
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
 
mlmccCommented:
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
 
Mikeyman_01Author Commented:
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
 
mlmccCommented:
Use the NEW PAGE BEFORE on the sections with the subreports.

mlmcc
0
 
Mikeyman_01Author Commented:
The 2nd subreport prints at the bottom of the second page...Should I remove any other page related information in the Section area??
0
 
mlmccCommented:
I would only because it tends to cause problems

mlmcc
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now