Hello,

I have a simple query with results I want to display in CR2008. The query is able to display all the data I want but when I run the report, it produces duplicates according to the number of results. The query draws results from 2 tables - a header and detail table. When a header has 4 details, you naturally get 4 rows when you run a query that joins these tables. There's no problem with the query. But when I run the report, I noticed that data in the detail table is repeated according to the number of resulting rows. For example, if I have 3 resulting rows from my query, the report shows the 3 rows 3 times also... and for 2 resulting rows, the report shows the 2 rows 2 times also...

I need help. I'm a newbie and I've been trying to figure this out for 2 days now... I need to know how to remove these duplicate rows...