Hi all, I want to create the following user roles: Sales Manager Browse and view all reports Purchaser Browse and view some reports CashierBorwse and view one report What I want is to have one folder containing all reports and depending on the user role the list only contains the reports defined by the role. Anyone who knows how to achive this? Thanks in advance! -Janne Hasslöf
You can manage security using Report Manager. Reporting services has a role based security model. See ms-help://MS.RSBOL80.1033/rswork/htm/rms_security_v1_8kqb.htm in Reporting Services BOL HTH Jasper Smith
Have you got the Reporting Services Books On Line installed ? The link to the online version is http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_security_v1_8kqb.asp The online version actually has new updated content not found in the copy that comes with the product. A downloadable update should be available soon but in the mean time the start page for it is http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp HTH Jasper Smith