web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Testing for SSRS Fetch...
Microsoft Dynamics CRM (Archived)

Testing for SSRS FetchXML Reports

(0) ShareShare
ReportReport
Posted on by VBDynamics 80

We have developed reports using SSRS and FetchXML available within CRM and needed to do some investigation into the possibility that these Reports could somehow be part of a nightly set of Acceptance Test scripts. Is there any suggested way we can automate testing for our Reports which are developed using SSRS and using FetchXML. Any pointers to tools, frameworks or how this can be achieved ?

Thanks & Regards

*This post is locked for comments

I have the same question (0)
  • David Jennaway Profile Picture
    David Jennaway 14,065 on at

    If you use CRM OnPremise, you can schedule reports use Reporting Services, but there's no equivalent option for CRM Online.

    One challenge when testing reports is the context-dependencies - i.e. the results can differ based on who runs the report, and whether it's run on a singe record, records in a view, or all records. You can manage these:

    • The user context is passed in the credentials when running the report
    • The record context (single record, view, or all records) is passed in the report parameters
  • VBDynamics Profile Picture
    VBDynamics 80 on at

    It was more like testing the results of the reports to see if the data is being returned correctly similar to the testing that we can have for plugins for example which can be automated.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans