SSRS report with stored procedure Dataset and aggregation by month - how to handle "empty" months?
<p>I have a SSRS report which calls a stored procedure to return a two columns dataset - one column is a <code>Date</code> and the other is a calculated column I created to show the month in the format <code>MMM-YYYY</code>.</p>

<p>Using this dataset I have created an aggregated bar chart report which shows the number of records per month for each month value which has at least one record in the dataset, however I would like to be able to include on the chart any months within the range of the dataset even if they do not contain any records.</p>

<p>So for example, where at the moment I see the following data points on my chart:</p>

<pre><code>Month        Count
-----        -----
Oct-2015     2
Nov-2015     5
Jan-2016     3
Feb-2016     6
</code></pre>

<p>Dec-2015 is missing because my Dataset didn't return any records for it, so I would like to be able to plot a zero Count value on the chart for this month.</p>

<p>Now I know how I would normally do this in SQL, with some kind of calendar table LEFT JOINed in so that I can return the months with zero counts, but can I achieve the same in SSRS with a stored procedure as the target of the main dataset?</p>