Skip to Content
0
Former Member
Feb 11, 2011 at 02:42 AM

Dynamic Parameter

28 Views

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.