>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.

Double check the data environment of your report. There is a combination of having (or not) the alias in front on the field names, and having (or not) the data environment filled in that causes the problem you describe. It's happened to me, and I've sworn off using the data enviroment in reports ever since.

HTH,