Filtering out duplicates on table reports

The low tech solution is to make a report of Type Summary (ie a Summary report) and group by Customer by Order.  That way you will get 1 row per unique Customer Order.

But if you need a table report, then I suggest making a Formula Checkbox field and use a Formula Query to identify the first duplicate, setting the checkbox to true.  Then filter the report to only include the first duplicate.

var text QUERY = 
  "{7.EX.'" & ToText([Customer Name]) & "'}"
& " AND " 
& "{9.EX.'" & ToText([Order Number]) & "'}";
// note in the above, set the 7 and 9 to be the field ID's of the customer name field and the Order Number, respectively.

// next we retrieve a set of Record ID's fo that Query

var text AllRecordIDs =
ToText(
GetFieldValues(
GetRecords($QUERY),3));

// next we flag as true if the First Query result is the Record we are on.
IF(ToText([Record ID#])= Trim(Left($AllRecordIDs)), true) 


// post back if there are any syntax errors and I did not actually test.