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