I am developing a report that has 5 dynamic parameters that feed off of each other:

The Business Unit selection filters Department.

The Department selection filters Cost Center.

The Cost Center selection filters Project Code.

The Project Code selection filters the Year.

 

Currently, I am using a filter table to provide the values, and it works fine in Crystal Enterprise.  However, I need to switch to a Stored Procedure that my DBA developed instead, and it requires the user AD ID to be passed in as a parameter.  The Stored Procedure returns the same fields as the filter table.

 

I can see the stored procedure in the Database Expert, but it asks for the parameter "@NetworkUserID".  I typed in {Current CE User Name}, but when I try running the report, I receive this error:

"Prompting failed with the following error message: 'List of Values failure: fail to get values.'.  Error source: prompt.dll  Error code: 0x8004380D"

 

Any ideas how to properly pass the {Current CE User Name} to the stored procedure?