MacroScope
Programmer
I want to create dozens of reports simultaneously, one for each salesman, by setting the date parameters. So, for May 1-May 31, I enter the dates and Salesman1's report is created with only his data, and all other sales reps get their own indivudual report containing only their data generated at the same time with the same click. I have no problem creating it individually, putting in Salesman1's name, for example.
What I'm trying to do is to create a one-click routine that will generate the dozens of reports for that date range simultaneously, each sales rep on his own page, and then print the entire pile with one print command. Grouping doesn't help as it prints it all on the same page. I want to be able to give each salesman his own individual report containing only his data and totals.
I'm suspecting the problem is somewhere in the query feeding the report. I have created a select query which outputs all the appropriate fields, but the problem is that the report doesn't stop for each salesman, and then start anew for the next one. It just runs them all together into one long report.
Does anyone have a suggestion on how to do that?
What I'm trying to do is to create a one-click routine that will generate the dozens of reports for that date range simultaneously, each sales rep on his own page, and then print the entire pile with one print command. Grouping doesn't help as it prints it all on the same page. I want to be able to give each salesman his own individual report containing only his data and totals.
I'm suspecting the problem is somewhere in the query feeding the report. I have created a select query which outputs all the appropriate fields, but the problem is that the report doesn't stop for each salesman, and then start anew for the next one. It just runs them all together into one long report.
Does anyone have a suggestion on how to do that?
