Hallo Vinish,
i read your articles on oracle apex topics and i find them very helping. Its my first question an oracle apex on such platforms please answer me to motivate to ask more questions.
I have an IG and i want to add a radiogroup column in this report.
I have the following query
select *
from
(
select
KDID,
TO_CHAR(RABKORR,'99G990D99') as RABKORR,
TO_CHAR(ADAT, 'DD.MM.RRRR') as ADAT,
APEX_ITEM.RADIOGROUP (1,decode(art, 'F',
'Teilnehmer',
'T',
'Station') )art2,
decode(art, 'F',
'Teilnehmer',
'T',
'Station') AS art,
TSID,
TO_CHAR(QDAT, 'DD.MM.RRRR') as QDAT
from
TMASOWN.GAZRABKORR
where TFSID = :APP_USER )
the art2 column is what i need to show as a radiogroup column, but i am not able to get desired output. Please correct my approach.
Thanks
Ranu
Vinish Kapoor
You can simply change the item type of art2 column to radio button instead of using APEX_ITEM.RADIOGROUP. But for a single value column, the radio button will not be the right choice I think. You can try to show a checkbox instead of a radio button.
ranu
Hi Vinish, Thanks a ton for such a quick reply .
Can you please also suggest how to use the checkbox instead of radiogroup. Should i change the query or should i change thc column attribute to checkbox(tried that but it didnt show the value of the column)
ranu
Hi Vinish,
The following is what i desire to achieve in my IG report. Please help
Vinish Kapoor
Ok follow these steps.
Modify the query as below:
Now for the art2 column, select the Radio group from the item type (properties).
Change the number of columns to 2.
Specify the source as static values and define the values as shown below:
For display: Teilnehmer Return value: F
For display: Station Return value: T
Save the changes and run the page.
ranu
Hi Vinish,
I did what u suggested and it gave me following report for art5, it still did not give me the radio button look in the art5 column. But i tried something in the sql query itself helped me get the desired result in art column (property :html and html expression:&ART.)
DECODE (ART, 'F', '<input type="radio" value="F" checked /> Teilnehmer <input type="radio" value="T" disabled/> Station', 'T', '<input type="radio" value="F" disabled/> Teilnehmer <input type="radio" value="T" checked /> Station') as ART
my question, why did the radio button did not appear in the art5 column?
Thanks in advance for your reply