the total is not a duplicate, as the timeval is different. The other values are probably the same, but they are not the ones you want to suppress. I am assuming that this occurs in the Detail section of the report.
the way that I get around this type of issue is to create a group, display the fields that you want in the group header (or footer) and suppress the details and the group footer (or header). This way you only see the header, and there is only 1 value (it happens to be the first value that CR sees for the group, but it only 1 value).
Otherwise you need to filter the data out in a stored proc or view as joining to the tables in a database directly will give you the duplication.
HTH
IP Logged
