Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

how to get the source code from .rdl file Expand / Collapse
Author
Message
Posted Tuesday, February 5, 2013 6:35 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, April 3, 2015 7:22 AM
Points: 1,243, Visits: 2,754
From 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.
Post #1415801
Posted Tuesday, February 5, 2013 11:36 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:49 AM
Points: 62, Visits: 326
hi,
Thank you very much...
Rds,
Dinesh
Post #1416019
Posted Tuesday, February 5, 2013 5:10 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 5:18 PM
Points: 544, Visits: 942
anthony.green (1/29/2013)
SSRS Diagnostic Reports - http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/

Deploy it to your SSRS report manager then use the Report Queries report.



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.
Post #1416171
Posted Wednesday, May 6, 2015 12:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 6, 2015 12:50 AM
Points: 1, Visits: 0
Dear Friend,

If you open the vs 2008 and add existing item also it will open only the edit part but we cant find out the stored procedure name....
Post #1683031
Posted Thursday, May 7, 2015 11:13 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, June 3, 2015 12:35 PM
Points: 573, Visits: 1,229
mohanraj.jsp (5/6/2015)
Dear Friend,

If you open the vs 2008 and add existing item also it will open only the edit part but we cant find out the stored procedure name....


Expand the node "Datasets." There double click the data set(s) of interest. In the resulting window under the Query menu, look for the "Query Type" and it will be under there. That is unless it is a direct call to the database and no stored procedure is used. You will just see the SQL text in this case.

Welcome to the forum, I hope this helps you , although I am guessing a bit as to your situation since you did not provide enough detail about your particular issue.
Post #1683778
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse