InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 11:00:57 GMT20http://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspx[quote][b]anthony.green (1/29/2013)[/b][hr]SSRS Diagnostic Reports - [url]http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/[/url]Deploy it to your SSRS report manager then use the Report Queries report.[/quote]Oh this is very cool! Thanks for the link. I had some reports I'd made for monitoring SQL Agent and looking at SSRS stats but this is way more complete.Tue, 05 Feb 2013 17:10:41 GMTdavoscollectivehttp://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspxhi,Thank you very much...Rds,DineshTue, 05 Feb 2013 11:36:15 GMTdineshvishehttp://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspxFrom the RDL, open in a text editor, Notpad++ is what I use. Search for <COMMANDTEXT> and </CommandText>. Your sql code will be between these two. If there is one or more dataaset, search those as well.Tue, 05 Feb 2013 06:35:47 GMTMichael_Garrisonhttp://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspx[quote][b]anthony.green (1/29/2013)[/b][hr]SSRS Diagnostic Reports - [url]http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/[/url]Deploy it to your SSRS report manager then use the Report Queries report.[/quote]Nice InfoMon, 04 Feb 2013 14:19:08 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspxSSRS Diagnostic Reports - [url]http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/[/url]Deploy it to your SSRS report manager then use the Report Queries report.Tue, 29 Jan 2013 03:01:16 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspxThere can be a Stored procedure in the rdl file so how can you know with out getting the rdl file to the BI. If me i would add the rdl file using BI and look for the data sets..........Mon, 28 Jan 2013 14:43:08 GMTsql_reportinghttp://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspx[quote][b]dineshvishe (1/17/2013)[/b][hr]I want sql statement from Rdl file then what to do ??[/quote]Load the rdl file into a solution and then get the sql statement from there.Otherwise, parse the xml looking for your sql statement.Thu, 17 Jan 2013 00:30:01 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspxI want sql statement from Rdl file then what to do ??Thu, 17 Jan 2013 00:25:03 GMTdineshvishehttp://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspxThe query and everything should be in the XML file.If you want to pull the report into a solution so you can edit in VS. Open an existing Report Project, or create a new one. With the project open right click on the Reports folder >> Add >> Existing Item. Browse for your rdl file and viola you have the report in a solutionSun, 09 Jan 2011 11:40:11 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspxHi All,Thanks all for your replies..from the rdl file i need to generate solution file, is there any tool or process there to get this.how do i know the logic or query they wrote to generate the report. Thanks and regards,prasanth.Sun, 09 Jan 2011 00:39:09 GMTprasanth_knvrhttp://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspx[quote][b]prasanth_knvr (1/5/2011)[/b][hr]Hi ,i have a rdl file that is displaying report, i want the source code of that rdl file.(since i don't have the solution file for that rdl file) can any on help me in this regard,prasanth.[/quote]One of the options for the Reporting Services Scripter is to create a solution file for reports already deployed on a SSRS server. Have a look at it here... http://www.sqldbatips.com/showarticle.asp?ID=62 It will download all of the selected reports into a nice tidy report solution so that you don't have to open/download each one separately.It has a variety of uses, mostly I use it to manage deployment from Dev/QA and Prod.-Luke.Thu, 06 Jan 2011 08:19:08 GMTLuke Lhttp://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspxAn rdl file is just an XML file. You can open it with virtually any text or HTML editor. It will probably contain everything you need to see.Come to think of it, you could probably also find everything you need in the report server database as well, but it will not be a nice tidy package like the rdl file.Thu, 06 Jan 2011 06:58:29 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1043489-150-1.aspxHi ,i have a rdl file that is displaying report, i want the source code of that rdl file.(since i don't have the solution file for that rdl file) can any on help me in this regard,prasanth.Wed, 05 Jan 2011 23:36:30 GMTprasanth_knvr