| Call Report 6i from Form 6i wih parameter [message #210955] |
Sun, 24 December 2006 02:48  |
|
|
Sir
I'm new to Oracle.I want to call a report from Form.. I m using Form 6i & Report 6i.
I'm using RUN_REPORT_OBJECT and passing a Parameter list to call report but I'm not able to get the Output in the report(header is getting generated but no data is being displayed) as parameter defined in report not getting mapped with the parameter in the paranmeter list
My code is As:
par:=create_parameter_list('JAGGA');
Add_Parameter(par,'p_salary',TEXT_PARAMETER,'1000');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'PARAMFORM=NO');
report_job_id := RUN_REPORT_OBJECT(report_id,par);
I've already defined a parameter named p_salary in report
If I modify my code as following I'm getting the correct Output
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'PARAMFORM=NO'||' p_salary=500');
report_job_id := RUN_REPORT_OBJECT(report_id);
I'm also getting the output from the report If I'm calling report using RUN_PRODUCT function the code is as:
par:=create_parameter_list('JAGGA');
Add_Parameter(par,'p_salary',TEXT_PARAMETER,'1000');
Add_Parameter(par,'PARAMFORM',TEXT_PARAMETER,'NO');
run_product(reports, 'c:\shakti_goyal.rdf', synchronous, runtime, filesystem, par, null);
Sir I want to know where I'm making mistake in writing code using
RUN_REPORT_OBJECT first code or I'm missing something in code or setting wrong properties. I'm not using any report server. Report is being generated through Report Background Engine...
Thanks in advance
Regards Shakti Goyal
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
