How to identify SSRS reports?

(0) Share

Report

Posted on by Tony Suslovich

109

I'm looking for a way to identify all SSRS reports in our CRM. As you know, most used ones are Report Wizard and Existing file (SSRS) reports. I only need to list all SSRS reports but cannot figure out where this data is stored. I checked our main CRM database (ReportBase table) and ReportServer database and couldn't find it. Anyone knows what SQL table this is stored in?

*This post is locked for comments

All responses (10)

Answers (1)

Tony Suslovich 109 on at

Like (0)

Report

RE: How to identify SSRS reports?

Thank you Wei. This still solves 95% of my problems!
Suggested answer

Alex Fun Wei Jie 33,626 on at

Like (0)

Report

RE: How to identify SSRS reports?

Hi,

unfortunately, this is out of my knowledge. At this moment, i dont know how to differentiate the report created using report wizard and SSRS(fetchxml).
Tony Suslovich 109 on at

Like (0)

Report

RE: How to identify SSRS reports?

Is there a way to filter out FetchXML reports created with SSRS as opposed to report wizard in this case?
Suggested answer

Alex Fun Wei Jie 33,626 on at

Like (0)

Report

RE: How to identify SSRS reports?

Hi,

The report that created using report wizard or ssrs (fetchxml). Both methods using same connection string

Report created using report wizard
Tony Suslovich 109 on at

Like (0)

Report

RE: How to identify SSRS reports?

Hi Goutam, yes I've seen this before. Doesn't answer my question unfortunately.
Tony Suslovich 109 on at

Like (0)

Report

RE: How to identify SSRS reports?

Hi Wei, yes that's what I figured. But my question still remains....if we have FetchXML reports actually created outside of Report Wizard, will they fall into this criteria?
gdas 50,091 Moderator on at

Like (0)

Report

RE: How to identify SSRS reports?

Hi Tony ,

I am assuming you may get your answer from below reference - not sure you may already viewed this . Let me know if its does not helps you.

community.dynamics.com/.../242967

hub.packtpub.com/introduction-reporting-microsoft-dynamics-crm
Verified answer

Alex Fun Wei Jie 33,626 on at

Like (2)

Report

RE: How to identify SSRS reports?

Hi,

check is the string contain below text.

For SQL Reports: <ConnectionProperties><DataProvider>SQL</DataProvider>

For Fetch reports: <ConnectionProperties><DataProvider>MSCRMFETCH</DataProvider>
Tony Suslovich 109 on at

Like (0)

Report

RE: How to identify SSRS reports?

Hi Wei, thanks for the reply. We actually use CRM on-prem, but regardless I can then use:

<ConnectionProperties><DataProvider>SQL</DataProvider> ?

What if we have an SSRS report that was created using FetchXML?
Suggested answer

Alex Fun Wei Jie 33,626 on at

Like (1)

Report

RE: How to identify SSRS reports?

Hi,

you can refer to below post.

[View:https://community.dynamics.com/crm/f/117/p/268143/759055#759055:750:50]

i understand you are using online, thus you can build a console application to achieve it

Result

after you get the body text, check is the body text contain <ConnectionProperties><DataProvider>MSCRMFETCH</DataProvider> ?

if yes, record it ( export into file or csv).