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

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.
djnnllAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mcv22Connect With a Mentor Commented:
   Create new report project in BIDS (Visual Studio)
    Add Existing item to new project
    Select the rdl file and add it to your project
    Create any data sources needed for the report
0
 
djnnllAuthor Commented:
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.  
0
 
djnnllAuthor Commented:
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.
0
 
djnnllAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.