Do you know anything about SQL? This can be done using a Command object and using SQL as your datasource. The pseudo code is:
SELECT CustomerId, Date, Max(field)
FROM table
GROUP BY CustomerId, Date
If you don't know SQL, then I would create two groups by the Customer Id and Date and then only show one of the group headers and not the detail rows. That would eliminate all the extra rows from being displayed.
Edited by BrianBischof - 06 Mar 2007 at 9:41am
IP Logged
