Grouping on Dates

I have a what u could call sales database, and with each sale a date is recorded

so when i make a graph Sales VS Date. it only displays data for the days that have sales, but i want each day there, even if there are no sales. so u can see the ups and very downs (where there are No sales)

what do u think?

oh i am using CR9

One way is to create an all_dates table in your db which has a single field day (date) and popuate it with every date in your potential range of sales dates. Then do a outer join in your crystal query to this table and you'll have included grouped dates that have no sales.

ok done, it works. thanks.