Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

While running the above page, we found that record-id need not be displayed since it is system generated number column and no manual intervention is required' Secondly Ledger-code is always generated from based on report-type, hence this column must be display only and not as enterable one' Report-type must have select list as Balance sheet item, profit and loss account item' Ledger-name column background color should be red and font color need to be as yellow: We will make an attempt to beautify the page tasks one by one as follows:

 

 

(A) Record-Id column should not display'

 

→ Edit Page 5

 

→ Under Page Rendering section region, select REPORT and click

 

→ Under Column Attributes