Hi all,
I’m working on an SSRS report and I’ve been stuck on it for days, so any help or ideas would be much appreciated!
The problem is that for some reason my report is duplicating rows, but not in a consistent way. And while I can hide duplicates easily enough, it is affecting my sum total.
Here is my report builder with my groupings
And here is my report output. I tried to find one that showed variance in duplication. The first EmployeeNum(3512) sum payhour is correct, but then 3824 shows a duplication of 3 of one row, and the total sum being what the payhour should be multiplied by 3. The final employee num(1363) shows what should be 2 differing clock ins, but is repeating 7 times on the full report.
I’ve also checked the data from a BAQ and it is accurate on the BAQ.
Any help or ideas are welcome and appreciated