Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Interactive Report, change Text color based upon value in another column

TexasApexDeveloperNov 12 2013 — edited Nov 13 2013

I have a sample report at this url:

workspace: homeworld

username: test_report

password: test_report

APEX version is 4.2.3, database 11g release 2...

Application #: 202 : IR REPORTS TEST

Page in question is page #2

I have the report setup and need to make the following change...

I have 2 columns: Comm and bonus,

   if the bonus > comm, I need to change the text color of the bonus color to Red

   if the bonus < comm, I need to change the text color of the bonus color to Green

   if the bonus = comm, I need to change the text color of the bonus color to Black

I have tried using code with the select and am NOT wanting that since it will be bundled with the data when downloaded as CSV or Excel.. Had thought about using the built in highlighting but that doesn't allow comparing a column to another..

Was thinking of a dynamic action, but not clear as to HOW to do it, so any help would be appreciated..

Thank you,

Tony Miller

LuvMuffin Software
This post has been answered by jariola on Nov 13 2013
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 11 2013
Added on Nov 12 2013
#apex-discussions
10 comments
18,291 views