>I have a product listing report, the report shows 50 rows which is the same number of rows in the table but it repeats the 1st product 50 times rather than show each product once.

David,

Check if Forms with Grids and printing reports FAQ #15515 applies to your situation.