Grouping Formula 1

[mtepfer]

I have a table of inspections grouped by unit number. Within each group there is 1 to 5 inspections and the number of days between inspections.

I am interested in displaying just those groups that have inspections over 30 days. When i tried the select expert, it would only show an individual inspection within a group of over 30 days. I need all inspections in a group to show if one is over 30 days. If there are none then leave them off.
EX Group 1619 would print both inspections, group 1632 would not show up.

0001619
13957 0001619 000227 04/14/2004 35.00
13957 0001619 000227 05/19/2004 0.00

0001632
9361 0001632 002436 04/06/2004 0.00
16293 0001632 002436 08/24/2004 0.00

 

[lbass]

If you have a field that specifies the number of days between inspections, create a formula {@>30}:

If {table.nodaysbtwinsp} > 30 then 1 else 0

Then go to report->edit selection formula->GROUP and enter:

sum({@30},{table.unitno}) > 0

-LB

 

[mtepfer]

Thanks worked perfectly!