News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) FetchXml reports

Microsoft Dynamics CRM (Archived)

FetchXml reports

(0) Share

Report

Report

Posted on by CRMFan

100

Hi,

I have created 10 different reports in SSRS using FetchXml. These are all Line graphs. For the first four reports, the FetchXmls were taken from one entity but having different conditions. I just retrieved the one unique field and the CreatedOn field from the entity. For the unique field, I used aggregate 'count'. For the Createdon field, I used groupby=true and dategrouping=year.

I would like to consolidate these reports into one single report so that I can have a more informative statistics for my data. Is it possible?

Please find below my intended output:

Any ideas?

Regards,

CRMFan

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

David Jennaway 14,063 on at

Like (0)

Report

RE: FetchXml reports

If the different conditions are all based on the one field, then you can just include that field in the FetchXml with groupby=true, and then use that field in the chart in the SSRS report. There are some limitations in the charting in SSRS, but it should be able to give the output you want

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans