Only 25 Records 1

[schief13]

CR11 SQL Database

This seems simple enough but... I have a simple report that lists open invoices. I want to limit the report to the highest 25 invoices. Looks like I could use the TopN or Topcount function but I am confused over the correct use.

Thanks

 

[lbass]

If you have a field, e.g., {table.invamt}, that you are summing to arrive at the invoice total, place that field in the detail section, insert a sum on it at the invoice level, and then go to report->group sort->topN: 25, and select "sum of {table.invamt}".

There must be an INSERTED summary to activate the group sort.

-LB