Press "Enter" to skip to content

Change Or Set Report Object Property At Run Time In Oracle Forms Using Set_Report_Object_Property Command

Sets the Report object property at run time in Oracle Forms of an report object.

The following are the Syntax of Set_Report_Object_Property:

PROCEDURE SET_REPORT_OBJECT_PROPERTY
(report_id REPORT_OBJECT,
property NUMBER,
value VARCHAR2
);

PROCEDURE SET_REPORT_OBJECT_PROPERTY
(report_name VARCHAR2,
property NUMBER,
value VARCHAR2
);

PROCEDURE SET_REPORT_OBJECT_PROPERTY
(report_id REPORT_OBJECT,
property NUMBER,
value NUMBER
);

PROCEDURE SET_REPORT_OBJECT_PROPERTY
(report_name VARCHAR2,
property NUMBER,
value NUMBER
);

See the example of Set_Report_Object_Property with the following link:
https://www.foxinfotech.in/2012/11/calling-running-report-in-oracle-forms.html

Parameter report_id specifies the unique ID of the report. You can get the report ID for a particular report using FIND_REPORT_OBJECT . 
Parameter report_name specifies the unique name of the report. 
property should be one of the following constants:
 REPORT_EXECUTION_MODE: The report execution mode, either BATCH or RUNTIME 
REPORT_COMM_MODE: The report communication mode, either SYNCHRONOUS or ASYNCHRONOUS 
 REPORT_DESTYPE: The report destination type, either PREVIEW, FILE, PRINTER, MAIL, CACHE or SCREEN 
 One of the following strings: 
 REPORT_FILENAME: The report filename 
 REPORT_SOURCE_BLOCK: The report source block name 
 REPORT_QUERY_NAME: The report query name 
 REPORT_DESNAME: The report destination name 
 REPORT_DESFORMAT: The report destination format 
 REPORT_SERVER: The report server name 
 REPORT_OTHER: The other user-specified report properties value  
 REPORT_EXECUTION_MODE: Value must be BATCH or RUNTIME 
 REPORT_COMM_MODE: Value must be SYNCHRONOUS or ASYNCHRONOUS 
REPORT_DESTYPE: Value must be PREVIEW, FILE, PRINTER, MAIL, CACHE, SCREEN, FTP, WEBDAV, ORACLEPORTAL, ORACLEWIRELESS, SECUREPDF, or BLOBDESTINATION, PLUGDESTYPE 
 One of the following strings: 
 REPORT_FILENAME: Value must be of type VARCHAR2 
 REPORT_SOURCE_BLOCK: Value must be of type VARCHAR2 
 REPORT_QUERY_NAME: Value must be of type VARCHAR2 
 REPORT_DEST_NAME: Value must be of type VARCHAR2 
 REPORT_DEST_FORMAT: Value must be of type VARCHAR2 
 REPORT_SERVER: Value must be of type VARCHAR2 
 REPORT_OTHER: Value must be of type VARCHAR2 

Vinish Kapoor

FoxInfotech.in is created, written, and maintained by Vinish Kapoor. It is built on WordPress, and hosted by Bluehost. Connect with Vinish on Facebook, Twitter, and GitHub.

You may also like: