Retreiving SQL from Ad-hoc SSRS Report
Posted on 2009-05-14
I have a user that created an ad-hoc report in SQL Server 2005. When I log into the SQL Server DB and export the report to an RDL file for editing, the DataSource is in XML (NOT SQL)and therefore when I load the RDL file in a Visual Studio Solution, I cannot click the Data tab and see the SQL for the report. Nor can I hit the preview button.
If I try and export the DataModel or Dataset from the DB and add it to the solution it does not add to the datasource section. It adds it under the report in the solution explorer.
I need to somehow get the exact SQL that this report has internally from the RDL which runs against a datamodel in the DB.