Notifications
Announcements
No record found.
Hello experts,
I need your help. I have an on-prem dynamics CRM 2016. I am trying to find out how many SQL based reports in my CRM 2016 so that it can be replaced with fetxhXML report. I don’t see any option in UI to identify SQL reports, however in DB side in bodytext I can see the contents of the RDL file which may help in searching with SQL query tags. Please let me know if any option to find SQL based report in my CRM 2016.
Thank you in advance!
Regards,
Chandan
Hello Chandan,
I checked the report entity and there is no attribute or something like that tells if the report SQL or FetchXml based. I'm afraid that you will have to download the report and analyze "DataSource" of the report definition in order to identify the report type.
I found the solution. SQL bases SSRS reports has <DataProvider>SQL</DataProvider> tag in bodytext. I just serached it with below fetchXML using XRMToolBox.
<fetch><entity name="report" > <attribute name="name" /> <filter type="and" > <condition attribute="ismanaged" operator="eq" value="0" /> <condition attribute="originalbodytext" operator="like" value="%<DataProvider>SQL</DataProvider>%" /> </filter></entity></fetch>
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 170 Super User 2025 Season 2
#ManoVerse 61
Gerardo RenterÃa Ga... 52 Most Valuable Professional
