507
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,537
Super User 2024 Season 2
#2
Martin Dráb
228,520
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (