Security in reports
I understand that Report Server supports role-based security such that users in the different Windows user groups have certain rights with reports.
In addition to role-based security, I'm investigating Reporting Services 2005 to see if it suits our needs to providing user-based security in reports. For example, user1 and user2 are both in the Windows Power Users group such that they can both browse a certain published report in report server.
However, in our application, we define our own security groups and say user1 and user2 belong to different ones, which means that we want to apply filters such that while both user1 and user2 can browse the same report, user1 and user2 will see different results.
For example, say a published report is supposed to list all products from the Sales data. However, user1 should only see domestic products in our application while user2 could see all products. When user1 runs this report, we want her to see only domestic products still.
Is this possible with MS Reporting Services 2005? We have looked into creating custom data processing extension for Report Designer/Server, but we're not sure whether we are heading the right direction.
Any help or pointers appreciated!!
