melvin74
Jan 15th, 2009, 03:35 PM
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!
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!