report design problem

[webcrab]

Hi!
My report always shows a specific record from a table double 20 than it should be (i want it to display the selected record only once -as it should be-and it make it appear many more )
What can I do tp prevent this duplication on the report?

is it something that concern with the report design i chose?
(i used the report wizard)

need you guys quickly!

Thanx!

 

[gemma-the-husky]

you must have a cartesian join / cross product - ie your query is not correctly related, so each record in tableA is matching against more records in tableB than it should.

Check the report query carefully.

you can set the report query to select unique items - but this is only where you expect the query to produce duplicates - and you shouldnt use this as way to fix a dodgy query.