Run same report with different parameters many times

[Bennie47250]

Is it possible to have the same query or report run many times over and the query or report would get the parameter information from a table? So if there are 10 different parameters in a table, the query/report would run 10 times. (some folks call this bursting) If yes, how?

I’m thinking that I could write a macro and each time the query or repot is generated, send it out via e-mail using the SendObject action.

Thanks
Bennie

 

[lespaul]

you could run a query and loop through the record set and create the SQL for your report and run it for each record returned from the table....



Leslie

Have you met Hardy Heron?

 

[SeeThru]

basically, I'd create a recordset (or array) that contained my 'where' clause for each report

Open Recordset
do while rst.eof=false
docmd.openreport "MyREport",,rst!WhereString
'send the report, save it, whatever
docmd.close acreport "MyReport"
rst.movenext
loop


I used a simlar thing to automatically create an excel sheet with 50+ tabs by using export commands rather than report opening.

SeeThru
Synergy Connections Ltd - Telemarketing Services