Hi Guys Please can you help me solve this, I need to create the attached report in SSRS but I cant get the Conditional formating to work like the one in excel.

Hi @Byron Buys , You may refer this link for help. It shows detail steps to meet your requirement. Create two new columns for “Min(Value)” and “Max(Value)”. Set “Name” property for minimum value and maximum value. Open the “BackgroundColor” property’s expression dialog box for editing its expression. =swicth(Fields!value.Value=reportitems!minvalue.value,"green",Fields!value.Value=reportitems!maxvalue.value,"red",Fields!value.Value>reportitems!minvalue.value or Fields!value.Value<reportitems!maxvalue.value,"white") Hide the two Max and Min value column. http://www.bigator.com/2012/04/26/spothighlight-minimum-and-maximum-values-in-each-row-in-matrix-report-in-ssrs/ Regards， Zoe If the answer is helpful, please click " Accept Answer " and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. Hot issues October

See Expression Examples (Report Builder and SSRS) => Formatting

SSRS Conditional Formating like in Excel

Accepted answer

ZoeHui-MSFT 33,126 Reputation points

2020-12-10T09:20:36.837+00:00
Hi @Byron Buys ,

You may refer this link for help.

It shows detail steps to meet your requirement.

Create two new columns for “Min(Value)” and “Max(Value)”.

Set “Name” property for minimum value and maximum value.

Open the “BackgroundColor” property’s expression dialog box for editing its expression.

=swicth(Fields!value.Value=reportitems!minvalue.value,"green",Fields!value.Value=reportitems!maxvalue.value,"red",Fields!value.Value>reportitems!minvalue.value or Fields!value.Value<reportitems!maxvalue.value,"white")

Hide the two Max and Min value column.

http://www.bigator.com/2012/04/26/spothighlight-minimum-and-maximum-values-in-each-row-in-matrix-report-in-ssrs/

Regards，

Zoe

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October
Please sign in to rate this answer.

1 person found this answer helpful.
Byron Buys 21 Reputation points

2020-12-10T11:02:54.093+00:00

Thank you for the feedback, I have done all the steps, but cant find the "reportitems!minvalue.value" reportitems, how do I get it or must I just type it in?

and I get this error:

The BackgroundColor expression for the text box ‘TRADEPRICE’ contains an error: [BC30456] 'ValueorFields' is not a member of 'Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.ReportItem'.

Byron Buys 21 Reputation points

2020-12-10T12:09:55.237+00:00

Now I get this error:

The BackgroundColor expression for the text box ‘TRADEPRICE’ refers to the field ‘value’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.

ZoeHui-MSFT 33,126 Reputation points

2020-12-11T02:06:06.107+00:00

Hi @Byron Buys ,did you rename the textbox name of the Max value and Min value? I renamed the Min value textbox name as ''minvalue".so the reportitems name comes with ''reportitems!minvalue.value', if your textbox name of the Max value is 'big', the reportitems name comes with ''reportitems!big.value".hope you could get my meaning.
Sign in to comment

SSRS Conditional Formating like in Excel

1 additional answer