Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2006
    Posts
    2

    Unanswered: How to suppress page header/Footer in the last page

    Hi All,

    I am a new member in this forum and also new to crystal report.
    Kindly can you please tell me how to suppress Page header and Footer in the
    Last page of the report.

    Thanks in advance,
    Prashanth

  2. #2
    Join Date
    Oct 2004
    Posts
    24

    Code it.

    Place the following code to your Crystal Report Designer. Use the same code for your page footer.

    '--------for Header--------------------------------------------------
    Private Sub rptPageHeader_Format(ByVal pFormattingInfo As Object)
    If PageNum.Value = 1 Then
    rptPageHeader.Suppress = True
    Else
    rptPageHeader.Suppress = False
    End If
    End Sub
    '-------------------------------------------------------------------

    Where Pagenum is the object that tracks the current apge number.
    Insert the "page number" field from the special field to your report.

  3. #3
    Join Date
    Jan 2006
    Posts
    2
    My requirement is to suppress Page Header and Footer in the last page of the report not in the First Page.

    Even I tried your code in CR9, it was telling there was a error in the code.

    Anyways thanks for your replay, pls let me know if you have any other idea.

  4. #4
    Join Date
    Oct 2004
    Location
    Cavite,Philippines
    Posts
    31
    Hi,

    Right-click on the Footer Section, choose Format Section. click the button beside the Suppress (No Drill-Down) under Common Tab and place this code...

    if pagenumber=TotalPageCount then true
    else false


    Hope,it works.

  5. #5
    Join Date
    Apr 2011
    Posts
    10
    Something simple like this saved me much time spinning my wheels... I've lurked her for a long time but now hope to contribute where I can

  6. #6
    Join Date
    Aug 2011
    Posts
    1

    Crystal

    Thanks Crystal 30!

Posting Permissions

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