Remove From My Forums

How to view Default Reports in SSRS Database

Question
0

Sign in to vote

Hello All,

We have installed the Microsoft Dynamics CRM2011 and Reporting Service Extensions.We are able to see the Default reports in MSDCRM2011 but in the reporting Services Database we are unable to view the Deafult Reports File Location Path.

Could you please Let us Know Where and how we can see the Default reports in the Databas.(In Reporting Services Database which i have given while installation unable to see the default reports).

Thanks

Monday, June 13, 2011 2:17 PM

Answers

0

Sign in to vote
Hi,

SSRS Stores all reports Rdl XML file into the Catalog table Content column (Image Data Type not readable) of the Report Server database (i.e. ReportServer)

You can refer to the following link for converting Report Rdl Xml file from Image Data Type to Readable Xml.

http://blogs.netconnex.com/2011/05/extracting-ssrs-report-rdl-xml-from.html

I hope this answers your question.
Jehanzeb Javeed

http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex Profile

If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
- Proposed as answer by Jehanzeb.Javeed Tuesday, June 14, 2011 6:39 AM
- Unproposed as answer by Jehanzeb.Javeed Friday, June 17, 2011 12:24 PM
- Proposed as answer by Jehanzeb.Javeed Friday, June 17, 2011 12:24 PM
- Marked as answer by Donna EdwardsMVP Saturday, June 18, 2011 10:47 PM
Tuesday, June 14, 2011 6:34 AM

All replies

0

Sign in to vote

I haven't tried this in CRM 2011, but you used to be able to navigate on the report server through IE to your web client for SSRS it was somethign like reportservername/reports or something like that.

Many of the reports would just show up as a GUID though so you would actually have to open them in order to find out which one they were.
Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!

Monday, June 13, 2011 3:12 PM

Moderator
0

Sign in to vote
Hi,

Are you looking for Dynamics CRM 2011 Reports Rdl file xml into the database? or reports in report server/manager? if you are lookign for the reports on the report server then on the root folder of report server CRM creates a new folder "/SharedReports/5.0.xxxx" which contains all the standard reports. In my case Url is:

http://myreportserver:5050/ReportServer?%2fSharedReports%2f5.0.xxxx&rs:Command=ListChildren

Report Manager Url:

http://myreportserver:5050/Reports/Pages/Folder.aspx?ItemPath=%2fSharedReports%2f5.0.xxxx&ViewMode=Detail

I hope this answers your question.

Jehanzeb Javeed

http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex Profile

If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
- Proposed as answer by Jehanzeb.Javeed Monday, June 13, 2011 6:32 PM
Monday, June 13, 2011 3:41 PM
0

Sign in to vote

Hi,

I could able to view the Reports through the Report server URL but How can i view the rdl File XML in the Report server Databases?

could you please help me out.

Thanks & Regards,

Tuesday, June 14, 2011 5:38 AM
0

Sign in to vote
Hi,

SSRS Stores all reports Rdl XML file into the Catalog table Content column (Image Data Type not readable) of the Report Server database (i.e. ReportServer)

You can refer to the following link for converting Report Rdl Xml file from Image Data Type to Readable Xml.

http://blogs.netconnex.com/2011/05/extracting-ssrs-report-rdl-xml-from.html

I hope this answers your question.
Jehanzeb Javeed

http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex Profile

If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
- Proposed as answer by Jehanzeb.Javeed Tuesday, June 14, 2011 6:39 AM
- Unproposed as answer by Jehanzeb.Javeed Friday, June 17, 2011 12:24 PM
- Proposed as answer by Jehanzeb.Javeed Friday, June 17, 2011 12:24 PM
- Marked as answer by Donna EdwardsMVP Saturday, June 18, 2011 10:47 PM
Tuesday, June 14, 2011 6:34 AM

Answered by:

How to view Default Reports in SSRS Database

Question

Answers

All replies