how to get the source code from .rdl file

Question

how to get the source code from .rdl file

prasanth_knvr

SSC Veteran

Points: 292
More actions
January 5, 2011 at 11:36 pm

#232731

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.

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

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.

Luke L SSC-Dedicated Points: 35547 More actions · Answer 2

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[/url]For better help with performance problems please read this[/url]

prasanth_knvr SSC Veteran Points: 292 More actions · Answer 3

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.

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 4

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

dineshvishe SSCrazy Points: 2308 More actions · Answer 5

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sql_reporting SSC Veteran Points: 299 More actions · Answer 7

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..........

Ant-Green SSC Guru Points: 113507 More actions · Answer 8

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.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Michael_Garrison Hall of Fame Points: 3110 More actions · Answer 10

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.

dineshvishe SSCrazy Points: 2308 More actions · Answer 11

dineshvishe

SSCrazy

Points: 2308

February 5, 2013 at 11:36 am

#1584542

hi,

Thank you very much...

Rds,

Dinesh

davoscollective SSCertifiable Points: 6405 More actions · Answer 12

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.

mohanraj.jsp Valued Member Points: 69 More actions · Answer 13

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....

MMartin1 One Orange Chip Points: 27795 More actions · Answer 14

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.

----------------------------------------------------