Hi!!
I'm using VB6.0 and crystal report 8.
I need to do a repor like next:

              TJU01 TJU02 TJU03
Depto 51 $100 21 $120 12 $200 11
Depto 52 $104 20 $140 12 $180 12



This is a relation that tell me the sales on any department in each store (example of store name TJU01), and the number of employees that this department have.

What I can't do is that Crystal allow me to put the sales and personal number in one row, this is what I obtain in Crystal:


              TJU01 TJU02 TJU03
Depto 51 $100 $120 $200
               21 12 11
Depto 52 $104 $140 $180
               20 12 12

Is there any way to do what I need with a cross-table?

(That is because I need to export the information to a Excel file)