Solved

highlight, turn bold field based on condition in another field

Posted on 2014-07-23
2
722 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
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

685 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