Create many reports individually

[Alan R]

Hi,

I have a database that produces a number of different reports by selection of a 'Create Report A', 'Create Report B' etc buttons on a form. On some occasions selection of one of these buttons may result in a number of different versions of the same report be created. At present when i create the reports, they are all created at the same time which when printing off isn't a problem.

Now i would like to email some of the reports but obviously only want to email them individually (different recipients), is there any way that i could make it such that when i select 'Create Report A' and its creates more than 1 report, each report is created / displayed individually? Incidentley, i use a 'Report Printed' check box to only create those that need to be printed and whilst i realise that i could go through all the records to individually select as Printed / Not printed to achieve the individual reports, it would be functionally easier if i could achieve this automatically.

Any help appreciated.

I thought i had read an earlier thread on a similar subject but can't seem to find it now, pointers / links welcome.

Regards

Alan

 

[gemma-the-husky]

i take it you mean a report is many paged, or multi departmental, as you only have a single report.

i had to do this, by writing special code to set the dept parameter etc, and then loop through a single report, resetting that parameter as appropriate, to do them all.

i think you may be able to use preview mode to pick and send selected pages, but i'm not sure

 

[Alan R]

Gemma,

Thanks for the info.

Essentially, my database produces for example, Payment Invoices. Whilst the layout is identical the information contained on them including Customer will be different so, if i wish to email i need to be able to separate out the reports.

It maybe that if it proves to difficult i will need to use a check box to force the system not to include them all in a print - somehow.

Alan