troubleshooting Question

Can CrossTab Report display fields with no data?

Avatar of mikmik74
mikmik74Flag for United States of America asked on
Crystal Reports
9 Comments1 Solution571 ViewsLast Modified:
Hello All..
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.

Please help!  
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros