View Full Version : Running Report for each value


jekirksey
06-24-2002, 12:47 PM
I need to run a report based on a query for each value in a field of the query. Here's what I have, a query that shows a list of users and projects. I would like to run a report that shows all the user's projects for each user, it needs to be a separate report for each one since I will be sending it to them with the SendObject command. Does this need to be a module? with a loop that moves through each value for users and runs the report using that as a filter (will that work) I am just stuck on the logic of running a separate report for each user...any help would be greatly appreciated. Thanks.

Alexandre
06-24-2002, 03:01 PM
I would say yes, you have to write some code in a module for that
Yes, the method you are describing seems to me to be the way to go.
No, you wouldn't run various reports in that case, but just successively apply various filters to the same report.

Give it a try a re-post if needed.