CrossTab Date Question

[melvin74]

I am making my first crosstab report and my rows are dates.
And my columns are users.

So lets say we are summing up the number of sales for a certain user on that day.

Currently if there is no sales then that date doesnt even show as a row. I would like to have all the days if i choose lets say a month date range even if no sales.

Curious how to achieve this? my only thoughts is making up some database with all my dates and doing a join on it.. maybe that would work dunno.

Trying to get similar to a weekly calendar.

Thanks!

[jggtz]

my only thoughts is making up some database with all my dates and doing a join on it.. maybe that would work dunno

I think that that is the best and sure way...
At least that's the way I would do it