Save a report snapshot

M

Michael Marquardt

Good morning, I have a report that is generated by a
query. There is a prompt for the district number and then
the report runs for that district. I want to save the
report as a snapshot but I want the district parameter to
be part of the file name. Right now I have a macro that
runs the report and save it in a file. But each time I run
the report for another district it overides the previous
file.
Also if I remove the district parameter and run the report
for all districts at the same time, can I have it save a
file at each change in district number?
Please help and thank you in advance.
 
Top