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
codeguru.com
Copyright WebMediaBrands Inc., All Rights Reserved.