Repeat Report Header

[Steph775]

Hi,

I was wondering if there was any way to repeat the Report Header on every page?

I had my header in the Page Header so that it would repeat on every page, but it did not have the CanShrink option so I put it in the Report Header so it shrinks when I want it to, but now it doesn't repeat. I was hoping there was some kind of code I could implement that would let me repeat the Report Header on every page.

Or is there a way that I could get the CanShrink property in the Page Header?

Thank you,
Steph

 

[vbaInet]

Can't be done in the Report Header, only in the Page Header. It has an Auto Size property as well.

 

[Geotch]

It can be done. Do you have data you want to show, totals or any calculations?

Here is a quick summary and some pictures. Create your report with the calculations in your header. Once it's finished, make a copy of it and hide everything except the report header. Now add this copy with the hiddend details in the page header of your original report.

 

[Geotch]

Every page will have the calculations in the top along with text in the report header.

Here is an example with the total count of the report showing on page 2.

 

[vbaInet]

It can be done.

Precisely what I said. It can't be done in the Report Header but can be done in the Page Header which is what you've showed.

 

[Geotch]

Sorry, read more into the post. I figured Steph wanted to see report summary calculations on each page of the report.

 

[vbaInet]

It makes more sense to the poster with the screenshots so thanks.