Thanks,
I tried a lot and it seems that Cross tab cants be used any where else, except the Summary band.
The problem is, I need a separate cross tab for each product code.
Lets say for product A, the pivot table is different.
For Product B, its different from product A