How to pass parameters from Oracle Form to Oracle Report?
how we can run oracle repoert from Oracle form and passing parameters from form to oracle report by Clicking Button
Software/Hardware used:
Software/Hardware used:
ASKED:
June 7, 2009 7:24 AM
UPDATED:
July 15, 2011 1:29 PM
RELATED QUESTIONS
- Passing Parameters in from Oracle Developer 10g Forms to Oracle Developer 10g Reports
- Determining server name in Oracle Forms 10g
- I do not want to open parameter form every time in Oracle Reports 6i
- Oracle report 6i, report has 2 parameters and runs fine independently but i run this report from a form with parameters; reports ignore the parametrs
- How to call word file from oracle report/forms 6i
Answer Wiki:
You have to declare a ParamList variable and add all necessary parameters to it.
Something like this:
<pre>Declare
l_parameters ParamList;
Begin
l_parameters:=Create_Parameter_List('l_parameters');
Add_parameter(l_parameters,<parameter_name>,Text_Parameter,<parameter_value>);
...
...
End;</pre>
Then you call the RUN_REPORT_OBJECT built-in to call the report, passing the parameter list.
if you are running your forms on the web, you will need to use the "WEB.Show_Document" built-in.
If you need further help, please provide more details (forms/reports version at least).
To see all answers submitted to the Answer Wiki: View Answer History.
Hi,
I need help in same. I have a report which I want to run from oracle forms. I have developed a report that generates a letter to be sent to previous employers of an e-mployee. The report has two parameters 1- selecting emp_name, 2-previous_employer_name. I have a form which has two columns (emp_name, previous_employer_name) values of which which I want want to use to pass parameter values to this report.
Example: I have an employee ‘A’ whose employment history I want to verify by sending letters to his ex-employers. He had been working for 3 different employers in the past 5 years ‘X’, ‘Y” and ‘Z’. Emp_name is already selected as fields from master data block. Now I want that when I press a button to run the report. The name of the ex-employers in the current field should automatically be taken as parameter while generating report.
Any help will highly be appreciated.
You didn’t say what exactly you need help with.
How to send parameters to a report is shown above, in the answer section.
how can i run report calling rtf format?
Mirshaid, please create a new question, to make sure your problem gets the appropriate attention.
When creating your new question, please be more specific, and provide as much details as possible.
Thanks,
Maojkumar, why do you need to pass 100 values ?
P.s. If you create a new question, you are probably going to get more answers.