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