Solved

highlight, turn bold field based on condition in another field

Posted on 2014-07-23
2
742 Views
Last Modified: 2014-08-01
I have a report with a column numeric name: cost change.

I would like to highlight and turn the font to bold in some cells when the value in cell cost change fluctuates +/- 2 cents.

Is there any chance someone can show me how the IIF would need to be coded?

Thank you.
0
Comment
Question by:metropia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Author Comment

by:metropia
ID: 40215613
I have this expression that does not work how I want it to work:

CASE
    WHEN (SUM(FavUnfavCostChange) < (2/100) THEN 'Less'
    WHEN SUM(FavUnfavCostChange) > (2/100) THEN 'More'
    ELSE NULL
END AS 'Flag'

But I get:

0.00000815000000000000            More    -- this is not more than 2 cents, is just a positive number
-0.00094700000000000000            Less     -- this is not less than 2 cents, is just negative number
-0.00222000000000000000            Less     -- this is not less than 2 cents, is just negative number
-0.00012250000000000000            Less     -- this is not less than 2 cents, is just negative number
0.00000000000000000000            NULL    -- this is zero so null is fine
0.01188576000000000000            More    -- this is not more than 2 cents, is just a positive number
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 305 total points
ID: 40216534
Since the only topic in this question is MS SQL Reporting, assuming this is in SSRS, you can edit the text properties by clicking on the text box, then right-click:Text Box Properties, then...

Fill Color, hit the fx button to the right of the Fill Color combo box, and in the Expression Editor enter this expression
=IIF(ABS(Fields!COST_CHANGE.Value) > .02, Yellow, White) 

Open in new window

... and Font, hit the fx button to the right of Bold, and in the Expression Editor enter this expression
=IIF(ABS(Fields!COST_CHANGE.Value) > .02, True, False) 

Open in new window

Change the name of the column, Yellow to whatever color floats your boat, and if  'cost change fluctuates +/- 2 cents.' means anything other than the absolute value of that column being greater than .02, we'll need to work with the expression.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question