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?