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!