We have created an SSRS report from SharePoint 2010 list. We have item level permission in the source list, so the user can view only the items for which they have privilege. But in SSRS report it picks all records without filtering out using access privilege.

Is there any option in SSRS to filtering out data using access privilege of current user? If not could you explain why?


Check if the SSRS report running via stored credentials. If so, it's connecting via the list with that account, not as the user.

  • Is there option to connect SSRS using current user credentials from sharepoint? – Hojo Mar 30 '15 at 6:55
  • That's one of the options in the data source, but as always, specifying that the current user should be used means that other features, such as subscriptions and snapshots won't work. – Mike2500 Apr 1 '15 at 11:57
  • Thanks. We can set "use current windows user" in credential section of data source property. – Hojo Apr 6 '15 at 12:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.