Solved

highlight, turn bold field based on condition in another field

Posted on 2014-07-23
2
659 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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

772 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now