Hi,
I am studying Oracle 6i Forms/Reports, how do I
pass a parameter from Oracle forms to Oracle reports ?
This is the syntax I used in the oracle forms, to print the so_totals report.
IF ID_NULL(CR_PARAM) THEN
cr_param := create_parameter_list('CREATEP');
ELSE
add_parameter(cr_param,'customer_pass',text_parameter,
my_cust);
END IF;
RUN_PRODUCT (REPORTS,'C:\REPORTS\SO_TOTALS',
ASYNCHRONOUS,RUNTIME,FILESYSTEM,CR_PARAM,NULL);
How do I read the 'CR_PARAM' parameter list,which contains the customer, to be printed in the oracle reports?
My goal is to print the SO based on the customer selected in the Oracle forms.
example > SELECT * FROM SALES_ORDER where customer_id = ?
Thanks.
I am studying Oracle 6i Forms/Reports, how do I
pass a parameter from Oracle forms to Oracle reports ?
This is the syntax I used in the oracle forms, to print the so_totals report.
IF ID_NULL(CR_PARAM) THEN
cr_param := create_parameter_list('CREATEP');
ELSE
add_parameter(cr_param,'customer_pass',text_parameter,
my_cust);
END IF;
RUN_PRODUCT (REPORTS,'C:\REPORTS\SO_TOTALS',
ASYNCHRONOUS,RUNTIME,FILESYSTEM,CR_PARAM,NULL);
How do I read the 'CR_PARAM' parameter list,which contains the customer, to be printed in the oracle reports?
My goal is to print the SO based on the customer selected in the Oracle forms.
example > SELECT * FROM SALES_ORDER where customer_id = ?
Thanks.