Click to See Complete Forum and Search --> : Selection/sorting


Bobpomm
May 31st, 2007, 03:54 PM
I have a report that has details within groups. Some of the detail is one record and others are two or more records. I need to be able to show just the groups with more than one record.


Who can tell me how to do this?

Thanks,
Bob

JaganEllis
May 31st, 2007, 04:56 PM
Try using the group selection formula, e.g.
count({table.field}, {table.grouped_field}) > 1

Bobpomm
May 31st, 2007, 05:14 PM
I can certainly try that but where do I put that formula?

JaganEllis
May 31st, 2007, 07:00 PM
Report menu, Selection Formulas, Group

Bobpomm
June 1st, 2007, 01:21 PM
It's a MIRACLE!!!! Worked like a charm. Thanks for the help