How to display report header with each group change

[KRel]

Hi All

I have a grouped report that I want to print out correctly. Currently when i preview the report I have only one report header.

I want to display the page header at the beginning of each grouped report.

I.e. Whole report has 33 pages, made of three grouped reports.
Report 1 - Pages 1 to 11 - Display report header section on page 1.
Report 2 - Page 12 to 22 - Display report header section on page 12.
Report 3 - Page 23 of 33 - Display report header section on page 23.

If possible I would also like the page numbers to restart at the change of each group.

I.e. Whole report has 33 pages, made of three grouped reports.
Report 1 - Pages 1 to 11.
Report 2 - Page 12 to 22.
Report 3 - Page 23 of 33.


Any help would be great! All Smart people please HELP!

 

[Mattster]

My guess is based on what you are saying the data types are all the same. Therefore you have three dataset that are the same report. I have done this by using View > Sorting and Grouping. Place the header in the category that seperates each reports data, and in the footer ensure a page break.

Conversely to that method you could use sub reports. So if these are all seperate reports. Create a new report, and drag and drop each of these reports into the new report, seperate each of your reports with a forced page break. The only thing to realise is that you will need to format the Page footer within the new report, since it will not carry over the footers from the other reports.

Hope this helps.

 

[KRel]

Mattster,

I tried you method but i get the same results, it is not working correctly. I need the report header to display at the beginning of each group report.

Thanks,

KRel

 

[Atomic Shrimp]

Mattster,

I tried you method but i get the same results, it is not working correctly. I need the report header to display at the beginning of each group report.

Thanks,

KRel

Can't this be achieved by just moving everything in the report header into the group header instead, then shrinking the report header down to nothing?

 

[Mattster]

I am unsure if I understand you correctly. Currently you are producing three different reports and you are trying to merge them into one or do you have three different datasets for the same report?

For option 1 three different reports.
1. Create a new blank report
2. Drag and drop the three reports into this report as sub reports.
3. Create the footer information within that section
4. place a forced return between each report
5. This should produce what you are looking for, (For sub reports both page headers and page footers are lost. Only page headers of the parent report is displayed.)

Option 2 The same report but different datasets
1. Define the query such that you can see all three datasets in one query
1a) Ensure that you have one field that differentiates between each peice of data, ie 1 for each row of dataset one, 2 for each row of dataset two
2. instead of defining the report header create a section header or footer for the peice of data that differentiates each dataset.
3. Define this header with the information that you wish to appear in the report header.

Either way this should work if I understand the question correctly.

 

[boblarson]

Can't this be achieved by just moving everything in the report header into the group header instead, then shrinking the report header down to nothing?

That would be the way I would think you would have to do it. The REPORT HEADER section itself ONLY prints once - period; at the beginning of the report. The GROUP HEADERS will print for each GROUP.