Header and Footer Help

[Acropolis]

This is probably quite simple, but I can't get my head round it properly at the moment.

I have a report which is used to create worksheets for engineers.

The page header and footer are always the same on each report, and contain the generic information needed for a job. The detail section, changes depending upon the job type, and displays a sub report for the appropriate job type. This all works fine.

The report is based around a single engineer, over a selected date range. Each worksheet should be no longer than one page.

What i need to add now, is a second page to capture some information about health and safety, the idea is that when they are printed, this is printed on the read of the job sheet. So if there are 3 jobs in the criteria, then there would be 6 pages in total, the health and safety page for each worksheet.

How can I go about setting this up? I've got report to extend over multiple pages before, but only by the volume of data in them, never by intentionally adding a second page to them, and how would I set it so that the header and footer only appear on the worksheet page, not the health and safety page as well?

Thanks

 

[plog]

Make a 3rd report that's a container. It will have nothing on it, but 2 sub-reports: The report and then the safety page.

Actually, it might have something on it if you are filtering the report. If so, you would need to use the same datasource the report has and link the container report and report via whatever fields you need to filter on. The safety report wouldn't be linked at all.

 

[Acropolis]

That wouldn't put the safety section in after each page of the worksheet report though would it? Wouldn't it only appear once at end of the report after all the worksheet pages?

I need it to appear after each and every worksheet page, so if there are 3 worksheet, there are 3 safety reports, one after each worksheet

 

[plog]

I think you could group the container report to accomplish this. You would have to make it be based on the same data source as the worksheets. You would make a worksheet grouping level in the container, then link it appropriately to the worksheet report--it would have to be linked so that only 1 worksheet shows (i.e. on a WorkSheetID field), then in the same grouping level right after that you put the safety report.

 

[Acropolis]

Solved it another way, after the sub report in the detail section i've put a page break, then another sub report with the safety report in it. This then puts the safety report on page 2 after each worksheet.

Then on the "OnFormat" event of the page header section, if the page number is odd make header and footer section visible, if even make them not visible.

This appears to be working for now.

Only problem will come if the worksheet goes over a single page, I need to double check, but i am fairly sure that i made the reports such that they will always be only a single page so this problem should never crop up.

 

[MaleNurse325]

The page break tool will allow you to stop the page and add an additional page to the report. I have a manual handling database and the back page of each report is a brief guide to manual handling. This is in fact a screen capture and is embedded as a picture file on the back of each report.