Sometimes you want to see only the most recent record, such as the latest activity for a customer or the most recent invoice from a supplier. To do that, in step 2 of the Quick Report Wizard, group on the field you want records ordered by, such as customer or supplier name, and in the Grouping page of the Field Properties dialog, turn off Retrieve all records and set Number of records per group to 1. Then in step 4, sort on an applicable date field, such as activity date or invoice date, and choose descending order. Because Number of records per group is 1, only one activity or invoice record is retrieved for each customer or supplier, and since the activities or invoices are in descending order by date, the most recent one is displayed.
© Stonefield Software Inc., 2023 • Updated: 06/07/16
Comment or report problem with topic