
Display all day of a month in a cross table in Crystal Report 8
Hi,
my problem is that in a cross table report, I want to display all the
day for a specific month. For example, I would like to know for all
project (line) how many hours I spent for each day (colomn). I get all
good values for that but because I have not work saturday, the colomn
doesn't appear because the're is no record for that day in the
database.
1 2 3 9 12
programming 6 4 8 4 1
analysing 1 3 0 3 6
I would like to display that (below) without creating a dumb table
with all day for a month and make an outer join with it. Is that
possible?
1 2 3 4 5 6 7 8 9 10 11 12
........
programming 6 4 8 0 0 0 0 0 4 0 0 1
analysing 1 3 0 0 0 0 0 0 3 0 0 6