Dynamic Reports

[akrishmohan]

Please solve this problem of creating dynamic reports.
I have a report rptMailingList which needs to be dynamically updated

from each row of the query.That is i shud pick up the data in the

first row of the query and create a report based on that.Similarly

the second and soon till the end of query.Each report shud then be

sent to the individual email addresses which is contained as one of

the fields in the Query.How would one do this??Please help??Note

that the report template is already present .I jus hav to update the

report dynamically from each row of the query.Thanks
Krishna

 

[GBall]

1. See the earlier post in this forum: Automatically emailing reports.
2. Define a table with your data. Use that table as the datasource for your report.
For each record in your mailing list, populate the table, run (and send) the report, clear down the table.

HTH Regards,
Graham

 

[akrishmohan]

but what if more than one table is involved????Could you plz provide a pseudo code...iam a beginner...Thanks