SQLTeam.com | Weblogs | Forums

One table in report builder triplicate results

Hello,

Please assist me. I have a table in Report Builder 3.0 as show bellow:


But when i run the report in it triplicates the output as shown below:

How do i avoid the duplicated information?

can you please give us the query used to pull the records. it will be helpful to identify the issues.

1 Like

SELECT FullName,
Mother,
Father,
ID,
Nationality,
BirtDate
FROM Person

The query is small and simple, i think the problem is in the tablix settings or on the grouping.
Please see the query below:
SELECT FullName,
Mother,
Father,
ID,
Nationality,
BirtDate
FROM Person

Selecting the distinct records will give no duplicates. this will solve the issue. also it will be always good to use unique key in table to avaoid the duplicate data's

If im wrong pls do correct me.