record selection on a summary field

[princessinthetower]

Is it possible to do record selection based on a summary field? I think this was not possible in early versions of Crystal and wonder if there is some workaround.

An example: select all customers whose total purchases > $10,000 last year.

 

[lbass]

You could limit records to last year in your record selection formula and then go to report->edit selection formula->GROUP and enter:

sum({table.purchases},{table.customerID}) > 10000

//assuming you have a group on {table.customerID}

-LB

 

[dgillz]

It is a group selection, not a record selection,that you need to do this. Lbass has it perfectly, as usual.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com