Color Coding data based on values

Question

Post reply

Color Coding data based on values

SQL Server

Old Hand

Points: 377
More actions
September 3, 2020 at 3:35 pm

#3786041

Hi Folks:
We have SSRS report (2016) with 2 columns Qty1 and Qty2 and want the record colored (red) If the Qty1 and Qty2 are matching. The Qty2 column has records in 5 decimal places and we want to round off to 3 decimal when comparing the values. I need help with formula.
In the above example the highlighted in red are matching.

Thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 1

https://www.mssqltips.com/sqlservertip/2612/data-driven-colored-text-for-reporting-services-reports/

pietlinden SSC Guru Points: 63503 More actions · Answer 2

=IIf(Round(Fields!Qty1.Value,3) = Round(Fields!Qty2.Value,3),"Red","Black")

SQL Server Old Hand Points: 377 More actions · Answer 3

I tried =IIf(Round(Fields!Qty1.Value,3) = Round(Fields!Qty2.Value,3),"Red","Black") and it is not working. Could it be because we have some NULL values?

This reply was modified 4 years, 2 months ago by SQL Server.

Phil Parkin SSC Guru Points: 246960 More actions · Answer 4

SQL Server wrote:

I tried =IIf(Round(Fields!Qty1.Value,3) = Round(Fields!Qty2.Value,3),"Red","Black") and it is not working. Could it be because we have some NULL values?

What does "not working" mean?

Results in an error? (If so, what is the error and at what point is it displayed?)
Makes no difference? (If so, exactly which property did you assign this formula to and for which object(s)?)
Something else? (If so, please provide fuller details of what you are seeing.)

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin