Crystal Reports...

Printable View

Nov 9th, 2000, 06:04 AM
Gary.Lowe

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.
Nov 10th, 2000, 01:31 PM

i have never tried this but...

i found this in the crystal reports help file:

Code:

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».
Nov 10th, 2000, 02:22 PM
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