Admin - Do you take advantage of 'Integrated Security' to do Payroll reports?

Payroll report should only show the records of the current user, Reporting Services support "Integrated Security" which you can use to identify the user who is running the report and only return relevant result for the current user.

❌ Figure: Bad example - Everyone can see others' rate changing history (maybe useful for administrative, but not for your employees)

✅ Figure: Good example - The current employee can only see his own record

To generate such a report, you need to use the filter on the data table:

Figure: Specify the filters on your data table and select Globals->User!UserID

Note: 'Edit Expression' dialog is only available on RS 2005, but the UserID global variable is available on RS 2000.