User Parameter in Dynamic List Report

ReportServer (EN)
1

Hi,

How to use user_id environment variable in the Dynamic List report to restrict the SQL output as per user.
Please guide.

Thanks,
Rijo Pius

2

Hi Rijo,

try this parameter ${_RS_USER.xx} to access the user properties and replace xx with: getFirstname(), getLastname(), getTitle(), getUsername(), getEmail() or getId().

If you are using the $P or $P! parameter use the following parameters:
_RS_USER_FIRSTNAME
_RS_USER_LASTNAME
_RS_USER_TITLE
_RS_USER_USERNAME
_RS_USER_EMAIL
_RS_USER_ID

kind regards
Marcel

3

Hi Marcel,

Thanks for your reply.
It’s working fine now.

Thanks,
Rijo

4

Hi

Sorry, I understood where I could use this parameters. Do I use these parameters in Where clause?

I saw in User management the option User variable management, but I can’t create or search a variable. Could I use it?

Do you have a example or sample about this configuration?

Regards

Cadu