InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 08:28:08 GMT20http://www.sqlservercentral.com/Forums/Topic841705-1063-1.aspxI have added Domain\Login to table also. Now Domain\Login is available.Thanks,MaheshWed, 06 Jan 2010 09:02:30 GMTbmr270http://www.sqlservercentral.com/Forums/Topic841705-1063-1.aspxLogin in a table.Thanks,BMRTue, 05 Jan 2010 09:00:45 GMTbmr270http://www.sqlservercentral.com/Forums/Topic841705-1063-1.aspxDo you mean you have either Domain\Login or Login in a table? Because that is what you will need.Tue, 05 Jan 2010 07:20:35 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic841705-1063-1.aspxPlease don't cross post. It just wastes peoples time and fragments replies. No more replies to this thread please. Direct replies to: [url]http://www.sqlservercentral.com/Forums/Topic841706-150-1.aspx[/url]Tue, 05 Jan 2010 07:20:28 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic841705-1063-1.aspxYes, I have employee ID's in my table. How to use them?Thanks and Regards,BMRTue, 05 Jan 2010 07:15:05 GMTbmr270http://www.sqlservercentral.com/Forums/Topic841705-1063-1.aspxYou'd have to have some way to match a user login to an employee. Do you have that information anywhere?Tue, 05 Jan 2010 06:53:19 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic841705-1063-1.aspxEnter Employee No: 123(Report Parameter) (By default, his/her employee_no for a team member, but manager can enter any team member Employee No and the manager can see details of all)Employee Detail Report:Emp_ No Emp_Name Emp_Sal Emp_Comm Emp_Rank123 xyz $5000 $2000 4If a manager opens the report, the manager can enter any team member ‘s EmployeeNo and the manager can see the details.If a team member opens the report, It should show his/her details only.(Means he/she should not have permission to see other’s details)/bmrMon, 04 Jan 2010 13:50:45 GMTbmr270