Report Security

Hi,

I have a certain report that contains information about a company structure... I want to allow only certain users to run the report (the easy part) but i also want the users to only see their own information (the hard part).

How can i achieve this?

Do i have to enable row based security over SQL Server 2005 table?

Best Regards

Hello,

You could use User!UserID to filter down your table to the data that each person should see.

Hope this helps.

Jarret