Hi Guys,
Newbie here. I am working on a report using oracle package/stored procedures with parameters inside WHERE clause of the procedure. But when I use the proc as my datasource, layout the report and run it, it worked fine. Not until i changed the property of one of any parameters from STATIC to DYNAMIC list of values. Now, show up the parameter pages twice. One page all parameters in STATIC and the second pages all parameters again, including the parameter that i made DYNAMIC. What is my problem here? IT is annoying for user to fill up those parameters twice.
Thannks in advance for your help. I am using Crystal Rep XI and Oracle 9i database(Oracle Native Driver).
Ed
Newbie here. I am working on a report using oracle package/stored procedures with parameters inside WHERE clause of the procedure. But when I use the proc as my datasource, layout the report and run it, it worked fine. Not until i changed the property of one of any parameters from STATIC to DYNAMIC list of values. Now, show up the parameter pages twice. One page all parameters in STATIC and the second pages all parameters again, including the parameter that i made DYNAMIC. What is my problem here? IT is annoying for user to fill up those parameters twice.
Thannks in advance for your help. I am using Crystal Rep XI and Oracle 9i database(Oracle Native Driver).
Ed