how to get the source code from .rdl file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » how to get the source code from .rdl file

13 posts, Page 1 of 2

1 2 »»

how to get the source code from .rdl file

Rate Topic

Display Mode

Topic Options

Author

Message

prasanth_knvr

Posted Wednesday, January 05, 2011 11:36 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, January 09, 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

Daniel Bowlin

Posted Thursday, January 06, 2011 6:58 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 11:53 AM
Points: 2,672, Visits: 2,416

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

Luke L

Posted Thursday, January 06, 2011 8:19 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:12 PM
Points: 2,891, Visits: 5,857

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

prasanth_knvr

Posted Sunday, January 09, 2011 12:39 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, January 09, 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

Daniel Bowlin

Posted Sunday, January 09, 2011 11:40 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 11:53 AM
Points: 2,672, Visits: 2,416

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

dineshvishe

Posted Thursday, January 17, 2013 12:25 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 3:31 AM
Points: 16, Visits: 176

I want sql statement from Rdl file then what to do ??

Post #1408182

SQLRNNR

Posted Thursday, January 17, 2013 12:30 AM

SSCoach

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:46 PM
Points: 18,732, Visits: 12,329

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 2008

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

sql_reporting

Posted Monday, January 28, 2013 2:43 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 2:42 PM
Points: 25, Visits: 126

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

anthony.green

Posted Tuesday, January 29, 2013 3:01 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

SQLRNNR

Posted Monday, February 04, 2013 2:19 PM

SSCoach

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:46 PM
Points: 18,732, Visits: 12,329

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

Post #1415493

« Prev Topic | Next Topic »

13 posts, Page 1 of 2

1 2 »»

Permissions