How can I change the page header name depending on subreport?

[acentler]

I got a report that has 5 subreports inside it. I want to be able to change the page header title depending on the subreport. I tried doing it using page numbers (see below) but sometimes one subreport is longer then the other and jacks that all up. There a way to do this formula using the subreport name?

if PageNumber >= 1 and pagenumber <= 6
then 'Ticket Volumes and Resolution Percentages'
else if PageNumber >= 7 and pagenumber <= 8
then 'Ticket Routing'
else if PageNumber >= 9 and pagenumber <= 10
then 'Ticket Resolution - Time to Repair'
else if PageNumber >= 11 and pagenumber <= 14
then 'Open Tickets - Volumes'
else if PageNumber >= 15
then 'Open Tickets - SLA breach'

 

[lbass]

There is a way to do this depending upon the section in which each subreport is located (they should be in different sections, e.g., RF_a, RF_b, etc.) and assuming you set "new page before" for each section containing a subreport. Please identify where they are located.

-LB

 

[acentler]

They are located in the Report Footer (a-e)

Thanks!!

 

[lbass]

The simplest solution would be to format your main report page header to conditionally suppress based on a formula:

onlastrecord

Then in each subreport, create a fake page header by creating a formula that includes all records:

whilereadingrecords;
1

Insert a group on this formula and check "repeat group header on each page" and then delete the groupname and add your page header text to the group header. Repeat for each subreport.

There is a way to use the main report page headers, but the above solution is probably simpler.

-LB

 

[acentler]

OK.. But the subreports are just a bunch of charts and tables that are in the report footers. Adding a group won't help me there will it?

 

[lbass]

Adding the group creates a fake page header in the subreport. It doesn't matter what the content of the subreport is.

-LB