You’re offline. This is a read only version of the page.
170
Hi,
I have created .net application and i am able to read data of Microsoft custom report using Microsoft SDK because it contains Fetch XML.
Same using Microsoft SDK , i am not able to read Microsoft CRM Pre-defined System reports data because it is SQL based.
Any idea, how can i read the data of system reports using Microsoft SDK or there is any other way to read such reports data?
Thanks in advance!
*This post is locked for comments
Thanks!
But in system report, i am getting the SQL in the dataset and MSCRM doesn't support SQL directly. So, how can we convert that SQL into Fetch XML.
You are using the FetchXML from the report and recreating the report in your code, right?
Similarly, for the system reports, you would need to 're-create' the data source in your code, as in:
1. getting the data sets
2. filtering and grouping through them
3. presenting the final result set.
Don't
If my answer helps you, please mark it as verified.
Correct.
Bingo,
So you are not reading the report actually.
You are using the FetchXML from the report and recreating the report in your code, right?
Similarly, for the system reports, you would need to 're-create' the data source in your code, as in:
1. getting the data sets
2. filtering and grouping through them
3. presenting the final result set.
If my answer helps you, please mark it as verified.
I am reading fetchXML from downloaded custom reports and pass that fetchXML using Microsoft SDK and read the report data.
When you say 'read custom FetchXML based report', do you mind explaining how you are achieving it?
Previously (in the on-prem deployments), we could 'talk' to the reporting services and get the custom reports in our .NET applications.
Did not matter what type of report it was.
But, since you are on an online deployment model, no way to directly interact with the reporting services.
So, how did you achieve rendering a fetchXml based report?! :)
You have to create fetch xml as per OOB report data.
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...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (