35
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
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>
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (