report with multiple data sources.

[gdanalakshmi]

I need to generate a report.

But I know the number of rows that appear in the report. I need to run a different query to generate each row in the report.

My question is should I create a temporary table and then feed the table to the datasource of the report or is there any another better way to do that??

 

[Pat Hartman]

If you are trying to make a single report from unrelated data, you can do it by making a bunch of reports and adding them to the main report's detail section as subreports.