Toad World® Forums

Running multiple SQL scripts in a single report?

Hello,

I am looking to be able to run multiple SQL statements in a single data report (TDR). Currently I have been running a single SQL statement per report, and so I am only able to produce a single set of results per page. To get around this, I am running multiple reports and consolidating them into a single PDF via an automation script, but that only gives one chart per PDF page, which seems like a waste of real estate.

Is this functionality currently available?

Thanks!

Hunter

Yes, you can do this through subreports.

Thanks, missed that button earlier!

I am running subreport with whole different SQL but the main report again gives the same report in both subreport , please suggest

Hello ml264h,

Thank you for your comment.

It seems that you found a bug in TDP. I created a task QAT-8443 for this issue.

Libor