Hi,
In SAP, I have a UDO created.
Basicall, when it opens, it show each user that has access to Crystal report server 2008 and by clicking a button at a bottom, it opens up another screen, to show list of cost centers this person can access.
In SQL, it has 2 tables that capture information about Cost centers that a user can access
(a) Master Table
Key User
1 ABU
2 JUDY
(b) Child Table
Key Line number Cost Center
1 1 61230
1 2 61500
2 1 61501
2 2 61600
In the Record Selection, I have a criteria U_User = CurrentCEUserID, so that user login to Crystal report server 2008 only see the cost centers they have accessed.
Eg: Judy only see 61501 and 61600.
Currently, I have a dynamic parameter, it will show a drop down for 61230, 61500, 61501, 61600.
How can I make it to just display relevant cost center based on user login to Crystal report server 2008 ?
Eg: When Judy login and run the report, she only see 61501 and 61600 for selection.