Thank you for taking your time to give me some help.
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;
IP Logged
