APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Conditional Report Link And Formatting

Gus CDec 19 2012 — edited Dec 21 2012

I have the following code that creates a link in a report
<select decode(job_action,'PR_START_JOB',''||job_name||'',job_name) job_name
>
If the job action = PR_START_JOB, then there is a link in white text.
If job action is something else then there is black text and no link.

Ideally, I don't want any html in my sql and I would rather use the report link column attribute, but it is not conditional
I have taking the style out of the sqk and putting it into the Column Formatting in the report atrributes using

<span style="color: white;font-weight:bold;">#JOB_NAME#</span>

This just changes the text to white for the ones without a link.

Any ideas appreciated

Gus

Edited by: Gus C on Dec 19, 2012 6:27 AM

Edited by: Gus C on Dec 19, 2012 6:27 AM

Edited by: Gus C on Dec 19, 2012 6:28 AM

Edited by: Gus C on Dec 19, 2012 6:28 AM

Edited by: Gus C on Dec 19, 2012 6:30 AM

This post has been answered by fac586 on Dec 20 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2013

Added on Dec 19 2012

#apex-discussions

13 comments

3,246 views