PDA

Click to See Complete Forum and Search --> : Page numbering


Rocketdawg
Oct 10th, 2008, 08:18 AM
Hi

I've got Crystal Report that won't put the page number on the bottom of the page. Sometimes it will show up on page 2, sometimes not until page 4.

The count is accurate when it does decide to show up.

I've got [pagenumber] of [totalpage] in the Page footer.

It's quite a long report with several Report Headers, Group headers and Details sections.

I've tried setting "New page after" using the section expert, but it doesn't seem to do what I expect.

What am i doing wrong?

Thanks!

Rocketdawg
Oct 10th, 2008, 09:12 AM
Hi

I figured out why its happening, but I'm hoping someone has a "best practice" to work around.

I've got 4 subreports that need to appear once in the report. Those are in the Header sections.

The page numbering doesn't begin until the page header section (I'm slow on the uptake sometimes)

Is there a way to number pages if the header section is really large?

Thanks

brucevde
Oct 10th, 2008, 12:37 PM
I have only ever used up to Crystal 9 so don't know if later versions offer other functionality. Regardless, this should work in any version.

Subreports do not have Page Header/Page Footer sections. A common technique is to create a "Fake" Group. The Header/Footer sections of this fake group then act as Page Header/Footer sections.

You could add a fake group in each subreport but I think adding it to main report would work just as well.

1) Create the following formula.
WhileReadingRecords;
True

2) Insert a Group based on the above formula. It must be the first group in the report.

3) Add a Group Header 1 section for each subreport.

Basically, this "Fake" Group will only ever print once but now all SubReports are contained within the Page Header and Page Footer of the Main report, so those sections will print when appropriate (Report Header/Footer sections are "outside" the Main Report).

The attached jpeg is a sample of how the Crystal Designer might look.

mabbas110
Nov 6th, 2008, 01:12 AM
I think you should create one more group and put page number field in that group. group i mean to say section.