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

(0) Share

Report

Posted on by Lee-Martin

509

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

All responses (2)

Answers (0)

Lee-Martin 509 on at

Like (0)

Report

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

Thanks, is that an expression or SQL code?
LuHao 40,872 on at

Like (0)

Report

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

Hi Lee,

Have you referenced this link?

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