Hello,
Following is my scenario:
I have two procedures in the package (Oracle). The first procedure just grab the state for all the members and the second procedure grab all the information and have 2 paratmeters in the declaration
PROCEDURE old_members (rpt_cursor IN OUT rpt_type,
rpt_state IN CHAR, rpt_BDate IN VARCHAR2 )
IS .....<procedure body>
Basically I created the first procedure, just to create dynamic values for all the states of the members and use that into the parameter of the second procedure. Both procedures are not linked when called in Crystal XI.
Everything is working fine except one issue
whenever I am refreshing the report, it first give screen to enter the username and password (Database) and then it gives me the window to enter the values of both parameter without using the values from dynamic prompt. Once I set both prompts as null and click ok, it asks me again for username and password and then give me the right values for the state paratmeter and other one is set blank.
I was just curious, how to stop Crystal from prompting again for username and password and giving me the first screen which does not carry to dynamic prompt.
Any ideas?
Following is my scenario:
I have two procedures in the package (Oracle). The first procedure just grab the state for all the members and the second procedure grab all the information and have 2 paratmeters in the declaration
PROCEDURE old_members (rpt_cursor IN OUT rpt_type,
rpt_state IN CHAR, rpt_BDate IN VARCHAR2 )
IS .....<procedure body>
Basically I created the first procedure, just to create dynamic values for all the states of the members and use that into the parameter of the second procedure. Both procedures are not linked when called in Crystal XI.
Everything is working fine except one issue
whenever I am refreshing the report, it first give screen to enter the username and password (Database) and then it gives me the window to enter the values of both parameter without using the values from dynamic prompt. Once I set both prompts as null and click ok, it asks me again for username and password and then give me the right values for the state paratmeter and other one is set blank.
I was just curious, how to stop Crystal from prompting again for username and password and giving me the first screen which does not carry to dynamic prompt.
Any ideas?