Results 1 to 4 of 4

Thread: Page numbering

  1. #1

    Thread Starter
    Hyperactive Member Rocketdawg's Avatar
    Join Date
    Feb 2003
    Location
    Back in the doghouse
    Posts
    294

    Page numbering

    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!

  2. #2

    Thread Starter
    Hyperactive Member Rocketdawg's Avatar
    Join Date
    Feb 2003
    Location
    Back in the doghouse
    Posts
    294

    Re: Page numbering

    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

  3. #3
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Page numbering

    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.
    Attached Images Attached Images  
    Last edited by brucevde; Oct 10th, 2008 at 12:40 PM.

  4. #4
    Addicted Member mabbas110's Avatar
    Join Date
    Oct 2005
    Location
    Karachi , Pakistan
    Posts
    172

    Re: Page numbering

    I think you should create one more group and put page number field in that group. group i mean to say section.
    Thanks and Regards,

    Muhammad Abbas

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width