Page header and Excel

[antmoe3]

CR Version 9.0. I have a report with data in the PAGE HEADER and data in the GROUP HEADER.

In the PAGE HEADER I have the company name. I want this to appear at the top of every page. This part works fine.

When I export the report into Excel, the company name appears on every page (Page 1,2,3,5)

Except one page (page 4).

The problem is that when the GROUP HEADER has more data in a group than the default Excel page size will allow, the page breaks but the company name no longer displays on the report on page 4. Page 4 has 18 rows of data left over from page 3 from the previous Group.

I have tried "Keep Group Together", and "Repeat Group Header On Each Page". However, the Group Header is not the problem. It's the Page Header. I do not see a feature for "Repeat Page Header On Each Page".

Does anyone know what I show do?

 

[lbass]

If the group header repeats as you wish, then create a formula that includes all records and set it to repeat group header on each page:

whilereadingrecords;
1

Place your page header fields in this new group header.

-LB

 

[antmoe3]

I need for the company name to repeat in the PAGE HEADER for each page.

 

[lbass]

I am suggesting that if the export is showing group headers repeating, then you could create a fake page header using the method I described, and then place the company name there. I don't know for a fact that group headers are repeating correctly, but you seemed to be implying that.

-LB