Sometimes you get duplicate sets of fields in the table but with different primary keys. I would personally write something in the script, as this is much more efficient but if I am doing this in the QVW I would use a chart object rather than a table box to display the number of records.
Use all the fields that you are interested in looking for as duplicates as the dimensions.
Then the expression will be = count(key_field)
or whatever the primary key is.
You can then either sort by the expression field, or set the expression to something like = count(key_field)>1 to list only the duplicates.
Adding further to above count(Key_field) expression gives the total count and count(DISTINCT key_field) gives the distinct count.. try this in any list box.
