Sponsored

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:
http://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 

Oracle Forms Recipes eBookDownload

Know how to use set_report_object_property to change the property of an report object in Oracle forms.

Post a Comment

V. Kapoor

{picture#https://3.bp.blogspot.com/-q3wCssWUHo8/ViDFfCpPEuI/AAAAAAAAD0M/MHPvgnl3T3U/s1600/authpic.JPG} Vinish Kapoor is a Software Consultant, currently working in a reputed IT company in Noida, India and doing blogging on Oracle Forms, SQL and PLSQL topics. He is an author of an eBook Oracle Forms Recipes, which is available on Google play. {facebook#https://www.facebook.com/foxinfotech2014} {twitter#https://twitter.com/foxinfotech} {google#https://plus.google.com/u/0/+VKapoor/posts}
Fox Infotech. Powered by Blogger.