January 4, 2010 at 1:50 pm
Enter 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_Rank
123 xyz $5000 $2000 4
If 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)
/bmr
January 5, 2010 at 6:53 am
You'd have to have some way to match a user login to an employee. Do you have that information anywhere?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 5, 2010 at 7:15 am
Yes, I have employee ID's in my table. How to use them?
Thanks and Regards,
BMR
January 5, 2010 at 7:20 am
Please don't cross post. It just wastes peoples time and fragments replies.
No more replies to this thread please. Direct replies to: http://qa.sqlservercentral.com/Forums/Topic841706-150-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 5, 2010 at 7:20 am
Do you mean you have either Domain\Login or Login in a table? Because that is what you will need.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 5, 2010 at 9:00 am
Login in a table.
Thanks,
BMR
January 6, 2010 at 9:02 am
I have added Domain\Login to table also. Now Domain\Login is available.
Thanks,
Mahesh
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply