Highlight cell or row in SSRS Tablix

Question

Hello,

I have a Tablix with multiple temperatures values for a patient taken in a day. Was wondering if I can highlight the row/cell with the highest temperature, in this case 101.5

Let me know if this can achieve via expression.

Thanks,

Ali.

Answer 1

Hi @Ali Ahad,

You may need to edit your dataset first to get the max value in your group.

I used below code and when the RNum=1, it will show the max value.

SELECT *,ROW_NUMBER()OVER(PARTITION BY ID ORDER BY TEMPA DESC) AS RNum
FROM TEST0613

And then choose the row and then go to background color, use below expression.

=iif(Fields!RNum.Value="1","red","No color")

You may set the visibility of RNum column as hide.

Answer 2

Hi @Ali Ahad,

Choose the row and then go to background color, use below expression.

=iif(Fields!temperature.Value=max(Fields!temperature.Value,"DataSet1"),"red","No Color")

Regards，

Zoe Hui

---

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

Answer 3

See

https://www.mssqltips.com/sqlservertip/5578/conditional-formatting-for-sql-server-reporting-services-reports/