title: SSRS - Group by Date expressions
body: <p>Using SS reporting service 2008, I'm looking at setting up a default report on sale figures through the month grouping by date.</p>
  
  <p>In theory it should look a little like:</p>
  
  <pre><code>Date         Total Sales    Qty 
  ----------------------------------
  01/04/2011   $15.00         3
  02/04/2011   $20.00         4
  03/04/2011   $00.00         0
  Etc
  </code></pre>
  
  <p>Problem I'm having is the days of the month that have no records are being skipped. (Like 03/04/2011 above).  Is there a way to show the dates that have no records?</p>