sjr40
June 10th, 2008, 07:37 AM
My sql server database contains managers who have staff.
The staff have scores for appraisal reports.
manager1 - staff1, staff2, staff3
manager2 - staff4, staff5, staff6
manager3 - staff7, staff8, staff9
I want to put my report in a CR viewer open to all managers with parameter selection for each manager.
When manager1 selects his name from a drop down list, only his 3 staff members should be displayed
(in another drop down list ?).
manager1 - staff1, staff2, staff3
He should then be able to select the individual staff member and view their scores in a report viewer:-
staff1, score1, score2, score3
Anyone know how I can do this ?
My current report has 2 parameters - manager and staff, but all staff names are displayed in the drop down
As long as the right manager and staff member are selected then the data will be displayed for that staff member.
This is just a secure access issue that i would like to address in Crystal X1.
The SQL used in an electronic form version of the report looks like this :-
SELECT name as display, name as name
FROM
tblAppraisal
WHERE manager LIKE tblAppraisal.manager
Thanks in advance
The staff have scores for appraisal reports.
manager1 - staff1, staff2, staff3
manager2 - staff4, staff5, staff6
manager3 - staff7, staff8, staff9
I want to put my report in a CR viewer open to all managers with parameter selection for each manager.
When manager1 selects his name from a drop down list, only his 3 staff members should be displayed
(in another drop down list ?).
manager1 - staff1, staff2, staff3
He should then be able to select the individual staff member and view their scores in a report viewer:-
staff1, score1, score2, score3
Anyone know how I can do this ?
My current report has 2 parameters - manager and staff, but all staff names are displayed in the drop down
As long as the right manager and staff member are selected then the data will be displayed for that staff member.
This is just a secure access issue that i would like to address in Crystal X1.
The SQL used in an electronic form version of the report looks like this :-
SELECT name as display, name as name
FROM
tblAppraisal
WHERE manager LIKE tblAppraisal.manager
Thanks in advance