reporting services - SQL Server - SSRS - Where to find query generating the report -
the guy created reporting using ssrs has left, , trying troubleshoot 1 of reports being generated. how access @ query generating report.
this give listing of reports xml report definition:
select name, cast(cast(content varbinary(max)) xml) reportxml reportserver.dbo.catalog type = 2 order name
the info want in datasets section, example below. there may more 1 query / stored procedure in report.
<datasets> <dataset name="salessummary"> <query> <commandtype>storedprocedure</commandtype> <commandtext>rptsalessummary</commandtext> <queryparameters> <queryparameter name="@startdate"> <value>=parameters!startdate.value</value> </queryparameter> <queryparameter name="@enddate"> <value>=parameters!enddate.value</value> </queryparameter> </queryparameters> <datasourcename>sampledb</datasourcename> </query> . . . </dataset> <dataset name="companylocation"> <query> <datasourcename>sampledb</datasourcename> <commandtext> select companylocationid id, name tblcompanylocation warehouseonlyind = 0 order description </commandtext> <rd:usegenericdesigner>true</rd:usegenericdesigner> </query> </dataset> . . .
see http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition/reportdefinition.xsd
Comments
Post a Comment