Showing posts with label generic. Show all posts
Showing posts with label generic. Show all posts

Friday, March 23, 2012

Report Model Security

Hello
Is it possible to filter data within a report model (.smdl). We have a
generic report model that we wish to limit, based on user credentials?
Kind regards
Ricky
(SS2005)Ricky,
Yes that's possible. Have a look at the documentation under "Security
Filters".
Also a good summary can be found here:
http://blogs.msdn.com/bobmeyers/articles/Implementing_Data_Security_in_a_Report_Model.aspx
You'll use the GetUserId() function in the model to tie to your data.
-Krip|||Thanks Krip.
Incidentally, did you manage to get your issues resolved?
"Krip" <anonymous@.anonymous.com> wrote in message
news:C71CBA81-089F-4091-9C6D-21F71FAA7AAB@.microsoft.com...
> Ricky,
> Yes that's possible. Have a look at the documentation under "Security
> Filters".
> Also a good summary can be found here:
> http://blogs.msdn.com/bobmeyers/articles/Implementing_Data_Security_in_a_Report_Model.aspx
> You'll use the GetUserId() function in the model to tie to your data.
> -Krip
>