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 Wednesday, January 5, 2011 11:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 9, 2011 5:40 AM
Points: 2, Visits: 17
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.
Post #1043489
Posted Thursday, January 6, 2011 6:58 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:41 AM
Points: 2,818, Visits: 2,552
An 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.
Post #1043720
Posted Thursday, January 6, 2011 8:19 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 7:20 PM
Points: 2,897, Visits: 5,978
prasanth_knvr (1/5/2011)
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.


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.


To help us help you read this

For better help with performance problems please read this
Post #1043793
Posted Sunday, January 9, 2011 12:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 9, 2011 5:40 AM
Points: 2, Visits: 17
Hi 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.
Post #1044953
Posted Sunday, January 9, 2011 11:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:41 AM
Points: 2,818, Visits: 2,552
The 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 solution
Post #1045021
Posted Thursday, January 17, 2013 12:25 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
I want sql statement from Rdl file then what to do ??
Post #1408182
Posted Thursday, January 17, 2013 12:30 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 6:55 PM
Points: 21,204, Visits: 14,889
dineshvishe (1/17/2013)
I want sql statement from Rdl file then what to do ??


Load the rdl file into a solution and then get the sql statement from there.

Otherwise, parse the xml looking for your sql statement.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1408184
Posted Monday, January 28, 2013 2:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:35 AM
Points: 25, Visits: 153
There 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..........
Post #1412667
Posted Tuesday, January 29, 2013 3:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:52 AM
Points: 5,131, Visits: 4,918
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.





Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1412849
Posted Monday, February 4, 2013 2:19 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 6:55 PM
Points: 21,204, Visits: 14,889
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.



Nice Info




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1415493
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse