I am creating reports for a company that has number of branches. The company don't want one branch to see another branch's data on the report. Is there any way to filter the data through the users' windows-login-id or mail-box-id so that if Branch 1 runs the report it can see data (records) pertaining to Branch 1 only and not Branch 2, 3, 4 etc..
DB : SQL Server 2000
CD : 8.5
Please answer.
Thanks.
DB : SQL Server 2000
CD : 8.5
Please answer.
Thanks.