Printing portrate and landscape from one report

[jrs]

I am creating a database for a company that tests vapor recovery systems. Currently, they do everything by hand on preprinted forms, which are required by the state. The entire testing process involves a series of six different tests that must to be reported to the state in the format of their preprinted forms. Which tests are conducted depends on the type of system installed and other factors. Different combinations of tests are conducted, but not all tests are conducted every time. One time they may only do one of the test and the next time they may do four of the tests.

One of the requirements of the preprinted forms is the continuous numbering of all preprinted forms in the “page x of y” format. Some of the preprinted forms are portrait and some are landscape.

I have two different thoughts on how to approach this situation. One would be to create a report that contained the preprinted forms as subreports. The page numbering would not be a problem, but I don’t know how to handle the combination of portrait and landscape page setups for the different subreports.

My second approach would be to create separate reports for each preprinted form and use a macro or code to print them. My problem here is how to handle the continuous page numbering in the required format (page x of y) across all the separate reports.

I am still in the design stage, but am looking for some suggestion on how to approach this problem when I get to it.

Thanks in advance.

 

[Fornatian]

I do not think it is possible to incorporate portrait/landscape views and printing into one report. (Someone, please prove me wrong.) You are left with one option, numerous subreports and a page numbering crisis.

My approach to this problem would be to use a global integer variable which is incremented then printed for each page. If you pre-run the report and record the sum of the pages and use that as a variable also then you may achieve continuous Page X of Y across all.