[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

Formatting when to force a new page

I am trying to format the layout of pages in a Crystal Report XI report that should always have ten pages. Here is the current layout:

PageHeader
GH2a = suppressed
GH2b = not suppressed, has section headers
GH3 = suppressed
DETAILS = not suppressed
GF3 = suppressed
GF2 = not suppressed

The sections not suppressed should begin printing on page one and I want a new page after GF2 as long as it's not the last page. There should be only one group 2 per page. I'm running into a snag though because if I put this formula (PageNumber<TotalPageCount) into the section expert for GF2, I'm getting very weird results. Page one doesn't have any records on it at all, but the 10 requested records are displayed on pages 2-11. I should always have 10 pages - period. Every record fits easily on one page and I want every page to begin with PageHeader followed by GH2b. It doesn't seem like rocket science, but I can't seem to get this report to format like I want it to.
0
Carla Romere
Asked:
Carla Romere
  • 8
  • 5
1 Solution
 
peter57rCommented:
Where is GH1 and GF1?
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
Both of those are suppressed.
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
I just found and tried this formula (Not OnLastRecord) in the GF2 NewPageAfter formula. That prints a blank page on page 1, but the rest of the pages are formatted correctly.
0
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.

 
mlmccCommented:
Try using NEW PAGE BEFORE on GH2.
Formula would be
Not OnFirstRecord

or
RecordNumber > 1

or

PageNumber > 1

mlmcc
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
Okay I'm still getting a blank first page. Then I get ten perfectly formatted pages with the randomly generated Batches. I also just noticed that every time I modify a control (resizing, etc.) it regenerates another whole set of 10 random records. Very bizarre.
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
By the way, mlmcc, this is the same nightmarish report you helped me with a couple of months ago.
0
 
mlmccCommented:
Can you upload the report?

mlmcc
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
Yes. I've saved it with data. I'm still working on revising some of the formulas yet again for objects in the report, but you can see it pulls a blank first page and then 10 nicely formatted reports after it.
PLANT-AUDIT2.rpt
0
 
mlmccCommented:
Could it be you are suppressing the first record?

I don't see any data in the report.

mlmcc
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
I'm saving it with data, I'm not sure why you aren't seeing the data. The first page is blank, but there are ten pages after that. I am using the formula you showed me last time to generate the random records - formula is called SelectBatch.
PLANT-AUDIT2.rpt
0
 
mlmccCommented:
I don't see any data it just comes up with the design.  There is no preview tab and no pages.
Did you check the SAVE DATA WITH REPORT option?

mlmcc
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
I did check to save with data and opened it up afterwards to make sure the data was there. I wonder if it has to do with the whole random records deal? Every time I touch a control it generates 10 new records. Maybe I need to change the random generation to the SQL view side?
0
 
mlmccCommented:
MIght be.  I suspect that may be what is causing the paging issue since you aren't on the last record at the end or the first record at the beginning.

mlmcc
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
Very bizarre problem. Will worry about it more later.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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