How to pass parameters from Oracle Form to Oracle Report?

5 pts.
Tags:
Oracle administration
Oracle Forms
Oracle Reports
how we can run oracle repoert from Oracle form and passing parameters from form to oracle report by Clicking Button

Answer Wiki

Thanks. We'll let you know when a new response is added.

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).

Discuss This Question: 8  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Niceali1976
    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.
    10 pointsBadges:
    report
  • carlosdl
    You didn't say what exactly you need help with. How to send parameters to a report is shown above, in the answer section.
    69,175 pointsBadges:
    report
  • Mirshaid
    how can i run report calling rtf format?
    10 pointsBadges:
    report
  • carlosdl
    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,
    69,175 pointsBadges:
    report
  • carlosdl
    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.
    69,175 pointsBadges:
    report
  • alsdkheel
    hello
    i want a syntax to call parameterfield  to crystal report from developer forms6
    e.g  emp_no or name
    10 pointsBadges:
    report
  • MariamKhan
    I want to display my report created in report builder to be displayed on m form when i click the show button. The report is not parametrized.
    How this can be done in a single piece of code?
    Any help will be appreciated.
    Thanks in advance

    10 pointsBadges:
    report
  • carlosdl
    @alsdkheel and @MariamKhan, please create a new question, to make sure your problem gets the attention it requires.

    When creating your new question, please include as much details as possible.
    69,175 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following