How to pass current user's login name as parameter to a RDL . (SSRS
integration with sharepoint)
Thanks to author @
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/751a3733-2e2b-49f8-8de5-8e692433091b/
The important point hers is setting the "=User!UserID " value to parameter
Goto parameters section and select the parameter which passes current user name as value,
right click on it, then select "parameter properties" .
Goto default valus tab, select "Specify values" Radio Button.
and in value field at bottom paste
[&UserID] OR =User!UserID
It passes the value as "domain\firstName.LastName"
in sharepoint list, the people or group field shows by default as "Name (with presence) "
change the type to "Account" for the field.
It should work fine
happy coding
No comments:
Post a Comment