M
mmohon
I've got one big report, and basically I want to slice and dice it,
and output it to different snapshot files automatically via a script
so I dont have to babysit it.
I know how to do the OutputTo to get it going to a snapshot file....
The problem is I dont know how to pass the Criteria to the underlying
query the report is based on.
In the Query I do. WHERE [CostCenter] = [Prompt] (prompt being a
arbitrary place I can put in cost center numbers)
How do I do this in VBA (or something like it):
[Prompt] = 4124 OR 3456 OR 5423
OutputTo blah blah snapshot.snp
[Prompt] = 1234
OutputTo blah blah snapshot.snp
basically, I want to 1: set the Criteria...2: Output Report, wash,
rinse, repeat.
Whats the best way I can do that
and output it to different snapshot files automatically via a script
so I dont have to babysit it.
I know how to do the OutputTo to get it going to a snapshot file....
The problem is I dont know how to pass the Criteria to the underlying
query the report is based on.
In the Query I do. WHERE [CostCenter] = [Prompt] (prompt being a
arbitrary place I can put in cost center numbers)
How do I do this in VBA (or something like it):
[Prompt] = 4124 OR 3456 OR 5423
OutputTo blah blah snapshot.snp
[Prompt] = 1234
OutputTo blah blah snapshot.snp
basically, I want to 1: set the Criteria...2: Output Report, wash,
rinse, repeat.
Whats the best way I can do that