i would like to write here my design coz i dont how to design it in crystal report 9, coz its difficult when i tried to create a cross tab in this followin design,

------------------------------------------------------------------------------------------

                          store1                 store2                 store3          and soon..

                    sales    TX  Px    sales   TX     PX   sales    TX    PX

Mar-1 tue    100       1   2      200      2       4    100      4      5

Mar-2 wed   200       2   3      400      4       5    300      6      7

 

Total sales   300                   600                      400

TX                 3                      6                          10

PX                 5                      9                          12       

-----------------------------------------------------------------------------------------

 

the field above store is dynamic and filtered according to what the users want with 3 columns below which are the sales,TX and PX for every store, i want that design in crystal report 9 using the cross tab design, followed by the total sales below and the rest of it..how can i do that, is there a way to design it  in cross tab or its difficult...please help me..

 

thanks in advance