Home » Developer & Programmer » Reports & Discoverer » Parameter form (10g)
Parameter form [message #319172] Fri, 09 May 2008 04:47
lakshmisaran
Messages: 26
Registered: May 2008
Junior Member
Hi,

I'm converting my form from 6i to 10g. Can anyone could guide me how to create parameter form when paramform is set to YES. I've done to this extreme. donno am into right path.

Add_Parameter(pl_id,'P_CUR_CODE',TEXT_PARAMETER,:TRA_LOAN_DETAILS.CUR_CODE);
Add_Parameter(pl_id,'P_GL_CODE',TEXT_PARAMETER,:TRA_LOAN_VIEW.GL_CODE);

Add_Parameter(pl_id,'P_FROM_DATE',TEXT_PARAMETER,NULL);
Add_Parameter(pl_id,'P_TO_DATE',TEXT_PARAMETER,NULL);

set_report_object_property(v_report_id,report_comm_mode, ASYNCHRONOUS);
set_report_object_property(v_report_id,REPORT_DESTYPE, CACHE);

set_report_object_property(v_report_id,report_desformat,'HTMLCSS');

set_report_object_property(v_report_id,report_server,'rep_server');

set_report_object_property(v_report_id,report_filename,fname);

SET_REPORT_OBJECT_PROPERTY(V_report_id,
REPORT_OTHER, 'pfaction='||hidden_action||' '||report_otherparam);

v_reportserverjob:=run_report_object(v_report_id);

where do i create the paramform. I'm new to this.

DL
Previous Topic: parameters in 10g reports
Next Topic: Oracle Drawing format
Goto Forum:
  


Current Time: Thu May 16 03:37:55 CDT 2024