So simple. Not sure how. As with a top 100 clause in a SQL query, how do you do this in a report, when ordered how you want it?

Thanks very much for that. It's doing exactly what I wanted. I knew there were formulae for that, but not sure what recordnumber was.

I've got to ask though - it does what you say: recordnumber > 10 gives just 10 rows. I thought recordnumber > 10 would give any count of rows as long as it was more than 10

That seems funny though. I'd expect to set recordnumber <= 10 to get 10 rows

Will you explain why it's like that? I like to understand.

Thanks
Mike

Also need to set a cutoff. Having a top currency value for a group, I need to set a lower boundary and I reckon this will be set in a section formula too. So listing rows ordering descending monetry value, How to I set no upper bound but cut off these rows at 200,000 and show nothing below that for particular groups (in specified order..)

 

Thanks!