Why you need to implement credentials yourself when SSRS is supporting Active Directory completely? Could you please provide more information about the situation?Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

Hi I have reports in reporting services which are currently controlled at report level using active directory groups. Currently users are allowed to see each others areas, but I have been asked to change this so that they cannot do this any more. If I had a generic report (e.g. the area report in the diagram below) currently the area can click on the figure to drill down and see each others breakdown. The security model I would like to implement would include the North Area only being able to see the North Areas area's data. I would like to do this using Active directory and somehow integrating it within my SQL and reports. I am able to take a download of active drirectory and import it into SQL to use it in query if required, but ideally I would like to link to AD somehow if possible?? Am I able to write something that would allow me to integrate the specific security group in my report e.g. SELECT * FROM areas WHERE area = 'north' and uid = SUSER_NAME() or SELECT * FROM areas WHERE uid = CURRENT_USER and area = 'north' I could of course write 4 instances of SQL to pull back a north report, a south report etc, but I do not want to have multiples of the same report as it becomes difficult to manage and maintain. Is there a way to paramaterise these reports e.g. have one main area report that you can pass an active directory report parameter to? Thank you,

Hi, First open your AD and define 4 groups, North, West, East and South and then assign users to appropriate groups. Now, go to report manager (open you IE and put your "reports" address in address bar). Click on a folder menu and select security: Click "Item Security" and then click "New Role Assignment" and then enter the name of the group that you want and grant sufficient access to them. Hope it helps. Cheers Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

Hi Thank you for your reply. This is what we are currently doing. I would like to integrate this security within the actual report using ismember , but am unclear how to go about it.