Crystal Reports populate date range on the fly

Message

Hi, 
I am trying to display all dates on a monthly basis which is supposed to have both value or null value in CR 2008( if null just display 0):
Date             total count
1/2/2012        0
2/2/2012        4
3/4/2012        1
4/4/2012         0
..
30/4/2012       5
I am trying to pass parameters in date ( from date, to date) from a stored procedure (execute on the database), then populate those date range on the fly:

ALTER PROCEDURE [dbo].[sp_Report_Dates] 

   @sFromDate datetime,
      @sToDate datetime
AS
BEGIN

 SET NOCOUNT ON;

   with ReportDates(calendar_date) as 
   ( 
 SELECT CAST(@sFromdate as datetime )
 UNION ALL
 select calendar_date + 1
 from ReportDates
 where calendar_date < @sToDate 
 )
 SELECT  ReportDates.calendar_date, E.LDTE, E.BRW FROM OND E 
 RIGHT OUTER JOIN 
 ReportDates ON E.LDTE = ReportDates.calendar_date 

END
Problems:
I think I should use date instead of datetime, however, the select calendar_date + 1 won't work;
My original goal is create a temp table ( one column only )  then populates the date range on the fly, then link that table ( date field) with another table's date field on right outer join;
the above SP doesn't seem to be working at all.
Please advise if there is a better way, such as create a table and/or view on the fly; or perhaps use SQL command from Crystal Report?Thanks in advance.
 JS