Customer Report

[JJAW]

We are currently using FM 5.0 I would like to be able to create a report that shows me our customers last order and the number of days since their last order. The key is I only want the report to show the last order only and not all the previous orders from the customer. Can this be done? Thanks for any help

[John Mark Osborne]

If you create a layout with a subsummary part by the customer field (no Body part), only one of the records from the customer will display. If you want just the latest record to display, sort by the order date field in descending order (in addition to the customer field required for the subsummary part).

To get the number of days since their last order, create a calculation with the following formula:

Status(CurrentDate) - OrderDate

Make sure the calculation is unstored so it will update whenever the current date changes.