ReportServer Forum

Ronen

Member

Registered: 2015-10-12

Passing value for user variable through URL

Hello

I have configured the httpauthexecute to be able to access specific reports.

The report I am accessing through URL has a user variable (UserClients) to which I want to pass a specific value. However when accessing the URL the returned report ignores the passed value and returns entries based on the executing user user variable.

Specifically  - this is the requested URL:

https://server/dir/dir/httpauthexport?id=102&format=pdf&user=Bilbo&password=Baggins&p_UserClients=4

UserClients is a list variable and the executing user has the list configured with the following values [1|2|3|4|5]. 

The returned report by the above URL is as if I am requesting the following URL:
https://server/dir/dir/httpauthexport?id=102&format=pdf&user=Bilbo&password=Baggins&p_UserClients=1|2|3|4|5

Can you please advice?

Thanks

Ronen

Thorsten J. Krause

Guest

Re: Passing value for user variable through URL

Hi Ronen,

unfortunately this is the expected behavior. One of the principles of user variables is that the returned values can be trusted and can not be manipulated by user input. You can either - if you don't mind the fact that there is no way to enforce the restrictions that might be implemented through user variables - replace the user variable with a standard parameter, or replace the httpauthexport with a mechanism to actually log in the correct user, some kind of single sign on, for example.

Cheers,
Thorsten

Ronen

Member

Registered: 2015-10-12

Re: Passing value for user variable through URL

Thanks Throsten.

I have read in the administrator guide that: p_ can be set to set a list parameter:
p_myparameter=abc|def, for instance, can be used to set a list parameter to abc and def.

Is this a parameter type that is different than a user variable?

Thanks

ronen

Thorsten J. Krause

Guest

Re: Passing value for user variable through URL

Hi Ronen,

in this context "list parameter" refers to a multi select Datasource Parameter.
If you add one of these to your report you can set its value with the syntax you mentioned.

Cheers,
Thorsten

Ronen

Member

Registered: 2015-10-12

Re: Passing value for user variable through URL

Thanks Thorsten.

I will check how I can use this for my needs.