Announcements
No record found.
Client is using basic SmartList - Employee Summary. Every employee that had wages for all months in the year is duplicated, those that worked part of the year are showing one line. How can I get the duplicated lines not to show in the results?
My thoughts are that the Employee Summary report in SmartList, is just pulling from the Employee Summary view in the company database.
If you run a SELECT script with this 'Employee Summary' view in SQL, against this same company database, do you also see the duplicated records, or no?
Dear,When I checked on the view which created for this Smartlist, I saw it might have the duplicated row if the employees have multiple records in the table UPR00901. You can fix by added the keyword 'DISTINCT' right after the 'Select' or in the JOIN CLAUSE of the first table, added 1more condition into the JOIN CLAUSE (I pasted my script there and remove the detail because it's so long, just keep the modify points there).SELECT DISTINCT RTRIM(dbo.UPR00100.EMPLCLAS) AS EMPLCLAS, ..... FROM dbo.UPR00900 WITH (NOLOCK) LEFT OUTER JOIN dbo.UPR00901 WITH (NOLOCK) ON dbo.UPR00900.EMPLOYID = dbo.UPR00901.EMPLOYID AND dbo.UPR00900.YEAR1 = dbo.UPR00901.YEAR1 INNER JOIN dbo.UPR00100 WITH (NOLOCK) ON dbo.UPR00900.EMPLOYID = dbo.UPR00100.EMPLOYID INNER JOIN dbo.UPR00300 WITH (NOLOCK) ON dbo.UPR00900.EMPLOYID = dbo.UPR00300.EMPLOYID
Hope this can help for you!
Best Regards,John Nguyen
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 616
André Arnaud de Cal... 460 Super User 2026 Season 1
Syed Haris Shah 331 Super User 2026 Season 1
