Subreports headers and footers

[cterjesen]

I have created a number of reports in a database.

I would like to create one report that combines all of these reports into one (so that they can all be printed to a .pdf file at once). The problem is when I add subreports, the report/page headers and report/page footers from the other reports do not print (only the detail does).

Is there any way to get around this?

 

[Andrew Fergus]

In answer to this question :

Is there any way to get around this?

Can you modify the original reports such that the main footer information (records counts and totals I presume) are in a group footer rather than a report / page footer? I expect the group footers would pass through onto the main report (untested so I may be proved wrong). This page from Microsoft has examples of subreports with subtotals.

HTH, Andrew.