SSW Foursquare

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

Last updated by Jeoffrey Fischer [SSW] 6 months ago.See history

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.

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

RSRulesPayRollByUserIDT2
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:

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

Jeoffrey Fischer
Reporting Services
We open source.Loving SSW Rules? Star us on GitHub. Star
Stand by... we're migrating this site to TinaCMS