Thursday, February 16, 2012

Can report results be filtered by Windows user login?

Good morning,

I'm in the process of creating a report to show employees and managers holiday and absence information. Is there a way of filtering the results of the report based on who is running the report, so that employees could only see their own information and managers could only see theirs and their subordinates information?

What I was hoping to do was create a lookup table which cross-references Windows logins with employee numbers and then use this information to pass a parameter to the SQL query, but I don't know how to retrieve the login from the machine being used to view the report.

I've heard about row level security and it seems ideal in theory but I fear the implimentation of row level security would be far beyond my meagre knowledge.

Any constructive suggestions welcomed.

Thanks,

Paul

Hello Paul,

Whenever you create an expression, take a look under the Globals node. One your options is User!UserID, this will give you the Windows login of the user running the report.

Hope this helps.

Jarret

|||

Jarret,

I came across the same solution a little earlier, works a treat.

Thanks,

Paul

No comments:

Post a Comment