Hi All

I have a report in crystal reports which is layed out in the following format.
Code:
Store         Cash  Cheque  ...  ...  ...  ...
1001  Sales   2.14   0.20   ...  ...  ...  ...
      Trans    167      4   ...  ...  ...  ...
      ATV    12.86  51.18   ...  ...  ...  ...
      Sales% 21.87   2.09   ...  ...  ...  ...
      Trans% 48.40   1.15   ...  ...  ...  ...

To

Store         Cash  Cheque  ...  ...  ...  ...

1051  Sales   0.67   0.15   ...  ...  ...  ...
      Trans     70      4   ...  ...  ...  ...
      ATV     9.31  38.49   ...  ...  ...  ...
      Sales% 13.44   3.08   ...  ...  ...  ...
      Trans% 43.47   2.48   ...  ...  ...  ...

Grand Total
      Sales   2.81   0.35   ...  ...  ...  ...
      Trans    237      4   ...  ...  ...  ...
      ATV    22.17  89.67   ...  ...  ...  ...
      Sales% 35.31   5.17   ...  ...  ...  ...
      Trans% 91.87   3.63   ...  ...  ...  ...
Now I have to change the report so it displays

Stores 1001 to 1042 and subtotals for these stores.

Stores 1043 to 1049 and subtotals for these stores

Stores 1050 to 1051 and subtotals for these stores

Grand totals for all stores.

Does anybody know if I can do this from the present report or will I have to rewrite the report.