SSRS Show Dates on Chart with Zero Counts

The users wanted a chart that had a count by day of a set of events. Some days did not have events and they wanted to see these days on the chart even though the days had a zero count. I tried to accomplish this with a CTE but I couldn’t get the CTE to return the data I wanted. So instead I looked for an SSRS solution.

My output looked like so:
2014-01-30_10-27-47

So then in SSRS I created a stacked bar chart, and did the following.

  1. Right Click on the Horizonal Axis and click Horizontal Axis Properties
  2. Change the Axis Type to Scalar (Number/Dates)
  3. Change the Interval to 1
  4. Change the Intervalt Type to Number
  5. Click OK

Executed the report and it is working as planned.

2014-01-30_10-31-17

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s