I am trying to replicate an access pivot table in crystal using the cross tab feature. This is my requirment.
customer Rep a b c d e f
date date date date date date
a date1 date4
date 2
date 3
b date 5 date 6 date 7 date 8
date 9 date 10
c
d
The customer is arranged in rows and Rep is arranged in columns. So i have got the intial layout. However how can i get the dates to be displayed? ( These are not summarized). For eg, there are can be 5 different dates associated to a Rep for a single customer. I need to get this displayed in a tabular format for all the customers and Rep. Can this be leveraged in crystal?
Thanks
Vin
Edited by: Vinnie_uic on Sep 30, 2010 9:24 AM
Edited by: Vinnie_uic on Sep 30, 2010 9:25 AM