Group Selection VS Record Selection 3

[dadazs]

Today I discovered that it is possible to do group selection.

I have never used group selection before. What are the main differences between record & group selections.

Many thanks

 

[briangriffin]

Record selection is used to filter out individual records - for instance, only return orders over $100.

Group selection is used to filter out entire groups of records based on summarized values - for instance, only return records for those customers who have total orders greater than $1000.

Record selection equates to the where clause in a SQL statement; group selection equates to the having clause.

 

[lbass]

The other important thing to note is that record selection returns the data to the report. Group selection is a secondary process that is selecting from the data already returned by the record selection process.

-LB

 

[kray4660]

I normally use group selection to filter out data where a group summary does not meat certain criteria (i.e., sum of products (by group) <> 0, thus fitering out groups where the sum of products is equal to 0).