How can I filter a report with duplicate fields in related records?

Posted by Graham Jones on Stack Overflow See other posts from Stack Overflow or by Graham Jones
Published on 2010-05-20T20:52:56Z Indexed on 2010/05/21 23:20 UTC
Read the original article Hit count: 206

Filed under:
|

I have a report where I need to filter out records where there is a duplicate contract number within the same station but a different date. It is not considered a duplicate value becuase of the different date. I then need to summarize the costs and count the contracts but even if i suppress the "duplicate fields" it will summarize the value. I want to select the record with the most current date.

Station Trans-DT  Cost    Contract-No
   8    5/11/2010  10         5008
   8    5/12/2010  15         5008
   9    5/11/2010  12         5012
   9    5/15/2010  50         5012

© Stack Overflow or respective owner

Related posts about reports

Related posts about crystal