Report - How would you do this?

[damienm]

Hi I need to create a report that can be filtered on a sequence column, i.e show only records 1+2.

First probelm, how would you go about sequencing records based on two criteria, product code and ETA date, basically I only want to display the next two shipments of a particular product on the report.

Basically I need the report to look something like the below, I must list enough orders to cover the forecast, I was thinking by sequencing the reports based on ETA and filter showing the 1st and 2nd order would normally cover the forecast quantity.

Product  Forecast        ETA        Order Qty
xxxxx         185        12/02/08     150