ADD THE CURRENT USER FILTER TO A WEB PARTĪdd a web part and choose the Current User Filter type from the Filters section. You can leave the parameter default as “Use Report Default Value”. Open the Parameters section and click on the Load Parameters button. Edit the web part and navigate to the report you created. You would add a web page, and configure a web part to be a SQL Server Reporting Services Report Viewer. ADD THE REPORT TO A WEB PARTĪdd the report to a web part as you normally would. Publish your report to the relevant SharePoint library, and navigate to the library and test that the report and the parameter is working as expected.
I won’t go into the details here of how to use ALL in your report, but you can read more here Ĭonfigure your user parameter as follows: ‘mydomain’ + LOWER(myuserid) AS UserAccount, Your query for the list of available values should look like this: You also want to add yourself to the list for testing purposes, otherwise you will get an error when looking at the Web part in SharePoint. So when creating the SQL Query for need to convert them to lower case. The SharePoint Current User Filter expects the domainuserid in the parameter list of available values to be all lowercase. CREATE THE LIST OF AVAILABLE VALUES FOR YOUR PARAMETER These are easy to do, but it took me a little bit of time to figure it out, so I’m blogging it here. The tricky part is formatting the domainuserid in your parameter so SharePoint can use it, and adding yourself to the list of available values so you can test that the Web part works as expected. In that case you want to have a list of Available Values in your parameter so that someone viewing the report in the library can pick from a list of users rather than have to know everyone’s user id.
However, in many cases the report does double duty as a report stored in a Report library, where users could choose multiple or ALL users.
You include the domainuserid in your main report query and filter the query on this value using a report parameter where the user value can by typed in. It is not an uncommon requirement to be able to publish an SSRS report to SharePoint and then use it in a Web part filtered by the user viewing it.