So much for the Crystal Reports Designer !!!

Can I read/search all the Parameter's default values ?

Here is what I need:

1) I had a Parameter called BatchType that has a list of about 50 types

such as :

24 Hour Double-Sided
24 Hour Single Page
24 Hour Single-Sided
48 Hour Double-Sided

and these value are populated at Designe time.

2) At run-time user can pick one of them (Discrete value) and this values will be in {?BatchType}. {?BatchType} is not an array and contains only 1 value selected.

 

During processing I need to find out all the default values by a Formula.

CAN I DO IT ?

 

Please help.

 

 

-Dell

YAH. I would have to hard code the list. I found the items in the list accessible if they are dropped in the multiple-values box. Dont you feel annoyed working with  Crytal Reports with or the limitations !!!

 

NOW, let's see if CR can do this.

 

CAN IT BE POSSIBLE  TO MAKE the special field: "Current CE User Name"

available inside my stored procedure so that I can do SQL using its value to filter data such as:

 

CREATE PROCEDURE sel_userdata (  
 )

 LANGUAGE SQL
 RESULT SETS 1                        

P1: BEGIN

 

--- The question is right here ???

DECLARE sCEUserName = Current CE User Name

 
DECLARE c_1 CURSOR WITH RETURN FOR    
SELECT * from USER_TAB where USER_TAB.username = sCEUserName

  
 -- Open Cursor -
 OPEN c_1;
 
 
END P1;

 

 

 

 

-Dell