Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » tabular display field
tabular display field [message #430075] Sun, 08 November 2009 00:07 Go to next message
salwa
Messages: 76
Registered: December 2007
Member
how to tabular display(no database item) field show in
tabular region
Re: tabular display field [message #430307 is a reply to message #430075] Tue, 10 November 2009 00:22 Go to previous messageGo to next message
sohan
Messages: 11
Registered: October 2009
Location: India
Junior Member
Hello Friend,

Hello Friend,I cannot get what u are exactly looking for?? Can u pls explain it in detail what u exactly want?
Re: tabular display field [message #431201 is a reply to message #430307] Mon, 16 November 2009 03:24 Go to previous message
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

Previous Topic: calculate (javascript)
Next Topic: how to sum to colum
Goto Forum:
  


Current Time: Thu Mar 28 17:01:02 CDT 2024