Making Page Header Optional?

[Meltdown]

Hi all,

I have a report with a sub-report in the OrderID footer. The page header is printing on all the pages in the report, however, I need to be able to turn off the page header if the page has the sub-report, as the sub-report has it's own page header with different values.

My pseudo code would be:
< If the report page has the sub report data then turn off/make invisible the Page header in the main report, for that page >

...the reports are all dynamic so I'll never know the page number the sub might be printed to.

Regards
Melt

 

[vbaInet]

What you're saying is you want to suppress the Page Header if there are records in the subreport?

In the Format event of the main report's Page Header section, the code to hide the section would be along the lines of:

Me.[COLOR=Red]PageHeaderSectionName[/COLOR].Visible = Me.[COLOR=Red]SubreportControlName[/COLOR].HasData

 

[Meltdown]

Hi vbaInet,

No, not suppress the page header if the sub has data, suppress the page header on the page that has the sub-data, only.

Using .HasData method turns the page header off for all the pages, which is not what I want.

Thanks for the reply

Regards
Melt

 

[vbaInet]

So the OrderID determines whether or not the sub-report should be shown on that page correct? If there's no related data to that OrderID the subreport appears invisible.

Are you Forcing a New Page per OrderID?

Perhaps a couple of screenshots might help.