how to get the source code from .rdl file

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

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

  • 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]

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

  • 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

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

  • 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

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

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

  • 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

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

  • hi,

    Thank you very much...

    Rds,

    Dinesh

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

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

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

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

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

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