Problem faced in grouping in chart in SSRS report

(0) Share

Report

Posted on by The CRM Developer

I am developing an SSRS report where I will show various charts.

The dataset of these charts is a custom entity/table in Dynamics 365 CRM. This entity/table has a whole number field/column capturing the lets say user count.

In one of the chart I am grouping the data first by Year and then by Month for which the record was created. I want the sum of the whole number fields for every month of an year as per the group.

I am able to achieve this but the problem is if I do not have any record for let's say January 2021, I should get 0 but not able to achieve this as there's no record present for January 2021 in CRM.

Any help is highly appreciated.

P.S. The SSRS report is a Dynamics CRM Fetch Xml report.

Thanks!

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Wahaj Rashid 11,321 on at

Like (0)

Report

Hi,

Thank you for your query.

As far as I know, this is not possible unless you store Dates Dimension data in a custom entity and link it up with you records.

Normally, these kind of charts are done in a data warehouse, where you have a time dimension and you do a OUTER JOIN to list all Mont/Year.

Was this reply helpful? Yes No