Crystal Reports...

[Gary.Lowe]

Hi All

I have a report in crystal reports which is layed out in the following format.

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.

i found this in the crystal reports help file:

Make Range Operator 

Operator (Symbol/Word)

to

Usage

x to y 

«Create the range x to y»

Example(s)

100.00 to 250.00  

«the range of consecutive numeric values beginning with 100.00 and ending with 250.00, including the end values».

Date (1990, 09, 01) to Date (1990, 09, 20) 

«the range of consecutive dates beginning with September 1, 1990 and ending with September 20, 1990. Both September 1 and September 20 are included in the range».

[jeffro]

You could try grouping or select expert. In the select expert you can use the is between and choose the store numbers you want to be displayed.

How this helps. Good luck

aja