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

Popular posts from this blog

apache - Add omitted ? to URLs -

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

php - How can I stop spam on my custom forum/blog? -