How to get sql query from the report , which has already been run

[inu]

HI Forum member,

Is it possible to get the sql query from the running report or already has been run the same, so that i can take that query and execute against the database for testing purpose...



With Regards
Inam

[BigChris]

You can't get the SQL from the output, but you can get the SQL from the query. In Report Studio, click on Tools in the menu bar and go to Show Generated SQL/MDX.