How make a report showing only oldest dated information per customer?

[Former Member]

I have a table with 4 fields: Customer name, Invoice Date, Invoice Number and Invoice Amount.

I am trying to create a report that shows only the oldest dated invoice for each customer.

For each customer I want to display customer name, invoice date, invoice number, and invoice amount for that record with the latest date.

[abhilash_kumar · Accepted solution]

Hi,

Here's how you can do it:

1) Create a group on Customer Name

2) Right-click the details section and go to Section Expert > click on the formula button beside Suppress and use this formula:

{Invoice.Invoice_Date} < Maximum({Invoice.Invoice_Date},{Customer.Customer Name})

3) And, then you can suppress the Group Header and Group Footer sections

Let me know how this works!

-Abhilash