Balance sheet

Oracle Apex - Balance Sheet

I have developed nice report to show the Balance Sheet using PL/SQL Dynamic Content.


Steps :

1. create a table to store the Main Account Details


2. Create table to store the sub account details


sample data as follows for Main Account Details



sample data as follows for Sub Account Details




3. create a PL/SQL Dynamic Content Region and write the below code














Balance Sheet main Report


Drill Down


Note : define the "GetInfo" javascript for drill down report, you must define it in Page Designer > HTML Header as follows



Comments

Post a Comment

Popular posts from this blog

Displaying Images in Oracle Apex

Image
Displaying Images in Oracle Apex Steps : 1. Create PL/SQL dynamic Content Region and write the code declare  cursor c1 is   select FILE_SHORT_INFO,emp_code from prtl_files where emp_code = :P8_empcd;  t varchar2(200); begin    for i in c1    loop     htp.p('<body>');htp.p('<p>&nbsp;</p>');        htp.p('<table width="100%">');         htp.p('<tr>');       for rec in (select * from PRTL_FILES                where emp_code = :P8_EMPCD and status='A')     loop       IF rec.ATT_MIMETYPE is not null or rec.ATT_MIMETYPE != '' THEN  htp.p('<td colspan="2">'); htp.p( '<img src="my_image_display?                          fid='||NVL(rec.FILE_ID,0)||'" height="'||100||'"/>' );    ...
Read more

Customize Apex Login

Image
How to customize Oracle Apex - Application Login Page Sometime i feel little dryness in Oracle Application login page, just like similar to below  While searching in internet i found below steps to change your login page appearances like below Application Express 18.1.0.00.45 Steps : 1. upload the files into your workspace Application Builder -- Shared Components - Static Application files  2. Write Below HTML - CSS code  in     a. Goto Page # 9999 (Default Login Page)     b. Goto Page Designer Property > CSS > Inline span.t-Login-logo { background-image: url(#APP_IMAGES#logo.jpg); background-size: cover; width: 400px; height: 204px; } .t-Body {   background: url(&APP_IMAGES.backround.jpg); } That's All, You can see nice login page during login.
Read more