I would not exclude duplicate rows. If there are duplicates, they need to be investigated. As an example, if an employee had the identical deduction code and amount for a single paydate, something may be wrong. It could possibly be a manual check that was updated, or there was a double...
It's probably because of the way the data is layed out in the view you are choosing. If you're using the V_Benefits table, a row of data will be returned for each Benefit Type assigned to an employee. Even if you restrict the benefit types in the selection criteria, it will return as many rows...
If you can base it on the system date when the report is run, you should be able to do something. If this is an ADP SQL database, you can use the @now function in date/time function. Then, you can use the @month command. So, your first calc may be @(month(@now))......then, you can use the...
Another way to do this would be to sort the report alphabetically, then by change date. Create a group and footer by name. Insert name, job title and change date in the footer. It will display the latest change date information. Then, you can hide the detail by clicking on format, section...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.