Announcements
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
<attribute name="dateRecieved" alias="MonthRecieved" groupby="true" dategrouping="month" />
Thanks
Lee
Thanks, is that an expression or SQL code?
Hi Lee,
Have you referenced this link?
social.msdn.microsoft.com/.../report-builder-30-how-to-display-all-months-in-xasis
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156