<div>
I still don't see the Designer tab to view the Sql. &nbsp;And don't see the Dataset pane. How do I get them? &nbsp;I only see the xml and only Server Explorer. &nbsp;<br />

</div>


I still don't see the Designer tab to view the Sql.  And don't see the Dataset pane. How do I get them?  I only see the xml and only Server Explorer.  


<div>
If I right click the .rdl that I create, I can click 'view code' or 'view Designer'. &nbsp;The 3rd party .rdl does not have these options, so I guess only the xml is available for viewing. &nbsp;I was hoping to view the Sql, but it appears it is not accessible, unless there is a way to access it.
</div>


If I right click the .rdl that I create, I can click 'view code' or 'view Designer'.  The 3rd party .rdl does not have these options, so I guess only the xml is available for viewing.  I was hoping to view the Sql, but it appears it is not accessible, unless there is a way to access it.

<div>
I had a .rdlc file, not a .rdl, so I did not have access to the Sql code, just the compiled version of the report.<br />
So, this is the correct answer if you have the real .rdl.
</div>


I had a .rdlc file, not a .rdl, so I did not have access to the Sql code, just the compiled version of the report.
So, this is the correct answer if you have the real .rdl.

<div>
<div class="content wysiwyg-content">
I am rebuilding the reports in Crystal Reports and need to see the .rdl sql. &nbsp;I have the .rdl and access to the database. &nbsp;I don't have the project or dataset with the sql. &nbsp;I do have dataset name from the rdl xml, but cant find the dataset or sql. &nbsp;So, the xml is all that is available when I open the .rdl in Reporting Services.
</div>
</div>


I am rebuilding the reports in Crystal Reports and need to see the .rdl sql.  I have the .rdl and access to the database.  I don't have the project or dataset with the sql.  I do have dataset name from the rdl xml, but cant find the dataset or sql.  So, the xml is all that is available when I open the .rdl in Reporting Services.

How do I locate the dataset and sql for 3rd party .rdl?

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.