SSRS - Fetchxml - displaying all months when requested even when they have no results

(0) Share

Report

Posted on by Lee-Martin

515

I'm working on a SSRS report. I want to display a monthly count of results.

To some degree I can do this, however if a month doesn't have any results, it won't give me a month or the count of 0

How can I force the report to display all months? I'm using a matrix to display the above, but I really need all months even if there are 0 results for that month.

My code is as below

Thanks
Lee

I have the same question (0)

All responses (2)

Answers (0)

LuHao 40,892 on at

Like (0)

Report

Hi Lee,

Have you referenced this link?

social.msdn.microsoft.com/.../report-builder-30-how-to-display-all-months-in-xasis

Was this reply helpful? Yes No
Lee-Martin 515 on at

Like (0)

Report

Thanks, is that an expression or SQL code?

Was this reply helpful? Yes No