Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » tabular display field
|
|
Re: tabular display field [message #431201 is a reply to message #430307] |
Mon, 16 November 2009 03:24 |
dbhossain
Messages: 155 Registered: August 2007 Location: Dhaka
|
Senior Member |
|
|
Dear Mr. Salwa,
I think i understand that you are looking for. you want to put a column that will be used for display only for caluculation or whatever but not database column / item in report grid.
if my understanding is ok with your requirement then i think the below SQL statement will be helpful for you.
SELECT
APEX_ITEM.TEXT(1,EID,20,20) AS EID,
APEX_ITEM.TEXT(2,ENAME,30,40) AS ENAME,
APEX_ITEM.TEXT(3,SAL,24,24,'style="width:50px;
text-align:right;"'
||'onchange="f_autoCal(this,'
||EID
||', '
||SAL
||');"',
'f03_' ||EID,
NULL)
AS SAL,
APEX_ITEM.TEXT(4,COMM,24,24,'style="width:50px;
text-align:right;"'
||'onchange="f_autoCal(this,'
||EID
||', '
||COMM
||');"',
'f04_' || EID,
NULL)
AS COMM,
APEX_ITEM.TEXT(5,' ',24,24,'style="width:50px;
text-align:right;"'
||'onchange="f_autoCal(this,'
||EID
||', '
||TSAL
||');"',
'f05_' || EID,
NULL)
AS TSAL
FROM
TEST_NAVIGATION
Here i have used for TSAL column :
APEX_ITEM.TEXT(5,' '........) here i have used ' ' symbol for a column that will hold the total salary value but not the database table column.
note: if you have a Table and associated columns as in the above SQL statement then you can copy and paste directly above SQL statement in the report datasource and execute to view the effect.
i think it will help you that you are looking for.
Note: if you type as below statement in the report data source
SELECT EMPNO,' ' AS NONDBASE FROM EMP
you will see in the runtime there are two column created EMNO & NONDBASE.
The output you can view in the attached file.
-- Kamal hossain
[Updated on: Mon, 16 November 2009 03:56] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Wed Dec 04 19:37:28 CST 2024
|