Crystal Report Design Help

Hello,I have to design a report which is more like a productivity report.
There is going to be a date range thats gets selected.
Say 2013-06-25 to 2013-08-25,I will have to create something like in the attached file.
I can skip the days,but how can I dynamically generate the dates in sql or in crystal and the query that iam using to generate one column in  the extract is below :
create table #tblposted
(
cnt integer,
ddofwk dateTIME
)

insert into #tblposted
SELECT COUNT(RXNO) CNT,DispenseDt DAYOFWEEK FROM HRXS LEFT JOIN KeyIdentifiers K ON HRXS.NDC = K.NDC WHERE DispenseDt between '2013-06-25' and '2013-08-25'AND NewRx=0 AND (CCType IS NULL OR CCType ='C') AND Reversed =0 GROUP BY DispenseDt union SELECT COUNT(RXNO) CNT,DIspenseDt FROM RXS LEFT JOIN KeyIdentifiers K ON RXS.NDC = K.NDC WHERE DispenseDt between '2013-06-25' and '2013-08-25'AND NewRx=0 AND (CCType IS NULL OR CCType ='C') --K.DeaClass IN('C-II','C-III','C-IV','C-V') AND GROUP BY DispenseDt order by DispenseDt DESC select SUM(cnt) as count,ddofwk from #tblposted group by ddofwk order by ddofwk desc drop table #tblposted 

Open in new window


How can I change my query so that say there is no data row returned for a particular date,it should still come up on the extract with zero count.
I think its a combination of both crytsal and SQL.Any ideas will help.
Thanks all.
screenshot.gif
Star79Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.