How to call a report made in Reports 6i into a Forms 6i Form.

5 pts.
Tags:
D2K 6i
Developer 2000
Oracle Forms
Oracle Reports
I need to call a Report made in Reports 6i into a Form made in Forms 6i.
ASKED: June 18, 2008  9:11 AM
UPDATED: May 1, 2012  7:52 PM

Answer Wiki

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

WRITE THIS CODE “WHEN BUTTEN PRESS” ON YOUR FORM

DECLARE
PARAMID PARAMLIST;
BEGIN
PARAMID :=CREATE_PARAMETER_LIST(‘TEMP’);
ADD_PARAMETER(PARAMID,’PARAMFORM’,TEXT_PARAMETER,’NO’);
ADD_PARAMETER(PARAMID,’****’,TEXT_PARAMETER,:block197.****);
ADD_PARAMETER(PARAMID,’DESTYPE’,TEXT_PARAMETER,’SCREEN’);

RUN_PRODUCT(REPORTS,’C:\***\***.rep’,SYNCHRONOUS,RUNTIME,
FILESYSTEM,PARAMID);

IF NOT(ID_NULL(PARAMID)) THEN
DESTROY_PARAMETER_LIST(PARAMID);
END IF;
END;

Discuss This Question: 5  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
  • Statement
    Select * from table1 where ep_id=100
    10 pointsBadges:
    report
  • AmjadRasheed
    sir how i call the last product purchase today by pressing button in forms? sir need the code to calling reports last and date wise (from date to date)?
    10 pointsBadges:
    report
  • 9597
    I intend to scan a document using a scanner and save the document in pdf into a blob column of the table. This i want to do using form 6i. Can u please let me know the requisite code.
    10 pointsBadges:
    report
  • a12asasasas

    lol u dont know how to call a report

    just type report_call_oracle_best_report('reportname');

    simple

    thanks for appreciation

    i know im best thanks

    20 pointsBadges:
    report
  • a12asasasas
    wiki answer is not correct   right answer is   WRITE THIS CODE “WHEN BUTTEN PRESS” ON YOUR FORM DECLAREPARAMID PARAMLIST;BEGINPARAMID :=CREATE_PARAMETER_LIST(‘TEMP’);ADD_PARAMETER(PARAMID,’PARAMFORM’,TEXT_PARAMETER,’NO’);ADD_PARAMETER(PARAMID,’****’,TEXT_PARAMETER,:block197.****);ADD_PARAMETER(PARAMID,’DESTYPE’,TEXT_PARAMETER,’SCREEN’); RUN_PRODUCT(REPORTS,’C:\***\***.rep’,SYNCHRONOUS,RUNTIME,FILESYSTEM,PARAMID); IF NOT(ID_NULL(PARAMID)) THENDESTROY_PARAMETER_LIST(PARAMID);END IF;END;
    20 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