Finding the "Top 100"

[Derek_Camfield_(Guest)]

I have a R&R report which aggregates amounts of money at a group level. What I would like to do is to only output say the top 100 group-level records in descending order of size of amount.____I have tried to do this in so many ways - can anyone help please.____Thanks.

[kfleming]

Create a total field that is a sum of the money field and resets at the group level. Make this total pre-processed. Then go to Database Sort order and make this your sort field descending.____Then create a second total that is a count of the group field name with a reset at the grand level.____Finally create a calculated field with the expression CNT<=100 where cnt is the grand total.____Then use logical properties on the group footer band to only print the line when the calculated field is true. Then only the top 100 groups will be displayed in the report.____Kathleen__R&R Support

[Derek_Camfield_(Guest)]

Thank you - you are a star! ____It was the idea of conditional printing which was new to me.:-)