Wednesday, July 11, 2012

SharePoint + SSRS Reports + Current User

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