ReportServer Forum

rijopius

Member

Registered: 2013-09-30

User Parameter in Dynamic List Report

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

Marcel Berger

InfoFabrik

Registered: 2012-03-14

Website

Re: User Parameter in Dynamic List Report

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

---

https://www.infofabrik.de
https://www.reportserver.net

rijopius

Member

Registered: 2013-09-30

Re: User Parameter in Dynamic List Report

Hi Marcel,

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

Thanks,
Rijo

cedispin

Member

Registered: 2014-12-12

Re: User Parameter in Dynamic List Report

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