Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Answered

How to identify SSRS reports?

Posted on by 105

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?

pic_5F00_reports.png

Categories:
  • Tony Suslovich Profile Picture
    Tony Suslovich 105 on at
    RE: How to identify SSRS reports?

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

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,626 on at
    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 Profile Picture
    Tony Suslovich 105 on at
    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 Profile Picture
    Alex Fun Wei Jie 33,626 on at
    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

    2335.16.png

  • Tony Suslovich Profile Picture
    Tony Suslovich 105 on at
    RE: How to identify SSRS reports?

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

  • Tony Suslovich Profile Picture
    Tony Suslovich 105 on at
    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 Profile Picture
    gdas 50,083 on at
    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 Profile Picture
    Alex Fun Wei Jie 33,626 on at
    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 Profile Picture
    Tony Suslovich 105 on at
    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 Profile Picture
    Alex Fun Wei Jie 33,626 on at
    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

    6560.13.png

    Result 

    6560.13.png

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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans