I am designing a report in CR v.10 with DB2 db and I don't have access to make changes to the db or create new tables. I tried to create a report using the cross tab report style to get the following look:
Jan Feb Mar ..........Dec Total
USER1 4 5 5 --
USER2 2 0 2 --
USER3 0 1 0 --
Total 6 6 7 0
There is a USERS table and a CALLS table. I am counting the number of calls per USER each month for a given year. I was using the month header from the CALLDATE field to display the months (if Month(CALLDATE) = 1 then 'Jan'), but how do I display the months where there are no calls for any USERS? I need to show all months for the year and place '--' in the columns that don't have data yet. By using the cross tab report it only displays the months that have USERS calls and the USERS that have CALLS. I need to show the both the USER and the month.