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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 display report according to user login

Author  Topic 

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-02-01 : 01:21:37
Hi,

i have 3 reports. say r1,r2,r3
And 3 user say u1,u2,u3.

i want reports will be display according to user login.
eg. u1 can only view r1.
u2 can only view r2
u3 can only view r3.

could u pls tell me the procedure.


Regards,
avijit

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-02-01 : 01:36:41
I think you have to manage that on the report server which user is able i.e. has the rights to view a report or not.
This is not to manage inside the report.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-02-01 : 01:43:44
thanks .
could u pls tell me how i can manage in report server.

Regards,
avijit
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-01 : 04:27:21
see

http://msdn.microsoft.com/en-us/library/ms156014.aspx
Go to Top of Page

avijit_mca
Posting Yak Master

109 Posts

Posted - 2010-02-02 : 04:46:37
thanks...now its working

Regards,
avijit
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-02 : 05:05:10
great
Go to Top of Page
   

- Advertisement -