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

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Suggested answer

Alex Fun Wei Jie 33,628 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Tony Suslovich 109 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

Alex Fun Wei Jie 33,628 on at

Like (2)

Report
Copy link

Link copied!

Hi,

check is the string contain below text.

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

For Fetch reports: <ConnectionProperties><DataProvider>MSCRMFETCH</DataProvider>

Was this reply helpful? Yes No
gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Tony Suslovich 109 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Tony Suslovich 109 on at

Like (0)

Report
Copy link

Link copied!

Hi Goutam, yes I've seen this before. Doesn't answer my question unfortunately.

Was this reply helpful? Yes No
Suggested answer

Alex Fun Wei Jie 33,628 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

Report created using report wizard

Was this reply helpful? Yes No
Tony Suslovich 109 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Alex Fun Wei Jie 33,628 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Tony Suslovich 109 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No