i'm creating a report in CR 8.5 whi

[azwaan]

i'm creating a report in CR 8.5 which displays recprds from a database.
i have grouped the report using a field. and i want the records relating to the group to be printed only if a summary field i have added for the group exceeds a particular amount.

other wise i need to suppress the whole group..with header and footer..

any ideas?

 

[lbass]

You could either do a group select (report->edit selection formula->GROUP) by entering something like:

sum({table.amount},{table.groupfield}) >= 1000

This would result in only groups with sums greater than 1000 being displayed.

Or you could go to format section->group header (and then group footer, and then details)->suppress->x+2 and enter:

sum({table.amount},{table.groupfield}) < 1000

After using either method, you will need to use running totals for further calculations, since non-group selected or suppressed records still contribute to the more usual summaries. However, if you choose the suppression method, you will need to add the opposite of your suppression criteria into the evaluate based on a formula section of any running totals you develop.

-LB