Results 1 to 5 of 5

Thread: Page Header

  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts
    A report(ReportA) have a chart under page header in Access 2003 db. Now I want to add another report as subreport(subreportB) in the ReportA. How I can I make the page header of ReportA invisible when page displays subreportB.

    I have tried simply using a 3rd report, and place each of your two reports into THAT report as subreports? But the chart under page header in ReportA won't display.

    Thanks in advance.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Page headers in subreports do not display in the main report. One option you might consider is to set the property of the chart to invisible, and then change it to visible if the subreport (ReportB) has no data - that is one of the code events that will fire for a subreport.
    Wendell

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by WendellB View Post
    Page headers in subreports do not display in the main report. One option you might consider is to set the property of the chart to invisible, and then change it to visible if the subreport (ReportB) has no data - that is one of the code events that will fire for a subreport.
    Thanks. The simply question to address my issue is: Is there a way to make a page header apply to a report without applying it to the third, six, nine page of the report?

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Page headers (unfortunately I guess in this case) apply to every page in a report. There is no way that I know of to have it print only on selected pages. You might be able to achieve what you are trying to do with Group Headers, but we would need a fair bit of detail about your situation to be able to determine whether that would work. Is it absolutely necessary that your chart be in the page header? Moving it to the detail section or to the report header might work...
    Wendell

  5. #5
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by WendellB View Post
    Page headers (unfortunately I guess in this case) apply to every page in a report. There is no way that I know of to have it print only on selected pages. You might be able to achieve what you are trying to do with Group Headers, but we would need a fair bit of detail about your situation to be able to determine whether that would work. Is it absolutely necessary that your chart be in the page header? Moving it to the detail section or to the report header might work...
    Thanks. Just find the solution for my case. I have added the following codes under "On Format" event of PageHeaderSection:

    If Me.Page = 3 or Me. Page = 6 then
    Me.PageHeaderSection.Visible = False
    Else
    Me. PageHeaderSection.Visible = True
    End If

    One more questions, what codes should I add to make Me.page = "auto increase three pages"

Posting Permissions

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