Display the SQL query used in the report

[systemsam]

Is there a simple way to display the query that a report used at execution time? I know you can see it in the logs (for trouble shooting purposes) but we wanted to be able to use it on the report itself - either set as a variable or just printed as a string. Can someone point me in the right direction?

If not - is there a way to pull the SQL from the querystring in the XML?

Thanks for your help

- Sam

[systemsam]

I've gotten as far as to find stuff like

com.mysql.jdbc.MysqlIO.sqlQueryDirect and seeing if I can get it out of jdbc but I can't figure out I need to get the query text into a variable.I'm not well versed in java but I feel like this shouldn't be too tough? Any words of wisdom?Sam