Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Alvin_SQL007
Starting Member
12 Posts |
 Posted - 2013-12-16 : 10:12:49
|
| Hi All,We have a SSRS Report Model (not a report) published to multiple users across our business (Around 25 users from 5 different offices). the problem is all the users have access to data related to all the offices when they are building Ad-hoc reports using Report Builder 3.0 and the published Report MODEL as their Datasource.we want to limit this so that people from a particular office should be able to see data that is related to their office only. How can this be done? please point me in the right direction.Many Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-16 : 10:27:35
|
| Pass the Username as a parameter to report dataset and then use it to filter for the required data.You can use User!UserID for getting the logged in user value.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Alvin_SQL007
Starting Member
12 Posts |
Posted - 2013-12-16 : 13:16:21
|
| Hi Visakh16,Thank you for your response. i understand we can do it at the report level, but we want to limit this at the SSRS REPORT MODEL level. so that if a user is using the REPORT MODEL as datasource, and building Ad-hoc reports using REPORT BUILDER 3.0 then by default the user should be able to see data that belongs to his/her office only. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-17 : 07:57:32
|
quote:
Originally posted by Alvin_SQL007
Hi Visakh16,Thank you for your response. i understand we can do it at the report level, but we want to limit this at the SSRS REPORT MODEL level. so that if a user is using the REPORT MODEL as datasource, and building Ad-hoc reports using REPORT BUILDER 3.0 then by default the user should be able to see data that belongs to his/her office only.
Then better thing would be to create report models specifically targeting each user groups and giving them access to required users.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
SSRS Report Model Security