oracle

[charlesjames]

how do we call reports from forms and also how do we call stand alone forms from another form?

[Motoma]

Welcome to The Scripts charlesjames,
You mistakenly posted your question to the Oracle Articles section of our site. I have taken the liberty of moving this post to the Oracle Forum, in hopes it will be picked up and answered by one of our experts.
Motoma

[amitpatel66]

how do we call reports from forms and also how do we call stand alone forms from another form?

To call another from from one form, use built in GO_FORM procedure:

To programmatically open another form, execute the OPEN_FORM built-in procedure:

OPEN_FORM('stocks');

By default, Form Builder immediately activates the opened form and sets focus in the form's first navigable item. To explicitly specify this default behavior, include the optional ACTIVATE parameter:

OPEN_FORM('stocks', activate);

When you open a form with ACTIVATE specified, Form Builder ignores (and never executes) any trigger statements that follow the call to OPEN_FORM.
If you do not want Form Builder to place focus in the opened form, include the NO_ACTIVATE parameter:

OPEN_FORM('stocks', no_activate);

When you open a form with NO_ACTIVATE specified, Form Builder executes any trigger statements that follow the call to OPEN_FORM after the opened form has been loaded into memory and its initial start-up triggers (if any) have been fired.
Whether you open a form with ACTIVATE or NO_ACTIVATE, Form Builder will fire any triggers in the opened form that normally would fire at form start-up. Potentially, these could include Pre-Form, When-New-Form-Instance, When-New-Block-Instance, When-New-Record-Instance, and When-New-Item-Instance triggers.

To close an independent form, execute the CLOSE_FORM procedure:

CLOSE_FORM('stocks');

[amitpatel66]

To execute a report from a form, use this built-in:

Description

Use this built-in to run a report from within a form. You can run the report against either a local or remote database server. Executing this built-in is similar using the RUN_PRODUCT built-in on a report.

Syntax

 
FUNCTION RUN_REPORT_OBJECT
  (report_id REPORT_OBJECT
);  
 
 

Built-in Type unrestricted procedure
Returns VARCHAR2
Enter Query Mode yes

Parameters

report_id Specifies the unique ID of the report to be run. You can get the report ID for a particular report using the built-in FIND_REPORT_OBJECT.

Usage Notes

n Returns a VARCHAR2 value that uniquely identifies the report that is running either locally or on a remote report server. You can use this report ID string as a parameter to REPORT_OBJECT_STATUS , COPY_REPORT_OBJECT , and CANCEL_REPORT_OBJECT.

If you invoke Run_Report_Object with a blank Report Server property, the return value will be NULL. In that case, you cannot then use the built-ins Report_Object_Status and Copy_Report_Object_Output, because they require an actual ID value.

[amitpatel66]

Example of RUN_REPORT_OBJECT:

 
DECLARE 
    repid REPORT_OBJECT; 
    v_rep  VARCHAR2(100); 
    rep_status varchar2(20); 
BEGIN 
    repid := find_report_object('report4'); 
    v_rep := RUN_REPORT_OBJECT(repid); 
    ...... 
END;