Skip to Content
0
Former Member
Sep 30, 2010 at 07:24 AM

A crosstab scenario

19 Views

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