Hi
Using Access 2010
I have a request to create a report that has 4 multipage reports in one
2 of these are summaries of the other two - but they want the summary reports as a separate listing not interleaved with their associated "detail" reports.
To explain further the 2 top level reports are by system - listing the performance of each system in a contiguous report - one for type 1 performance, the second for type 2 performance.
These 2 top level reports are then broken down by subsystem in the third and fourth report - again these report detail only the subsystem performance - and not to include the aggregated system data as a footer might be used to do.
If I put 2 multipage sub reports on one report - it works in design mode - but if I save the report and run it it complains that the report is bigger than the page (which is true) and then only displays one report without its header and then only the first few records that fit in the page. The second report is not visible and there are no scroll bars.
When I print it to paper or .XPS file it sort of works but there are blank pages after each page of the report.
I was going to supply one query that gave all the data at subsystem level and then let the report pull the relevant fields.
I need to get rid of the blank pages and I would like parameterise the sub reports so I can use 1 sub report "template"
and pass the data type and node type (system or subsystem) from the master report.
I thought this would be easy ... but oops I need some help with this one!
I could drive the 4 reports from the C ++ front end code easy enough - but I guess there is a smarter way of doing it ...
Thanks in advance for any advice kindly proffered
regards
10 Pints