2

I can return the value in a tablix cell with me.value. My objective is to simply use a background color to show that a value is different, compared to the value above. The tablix is sorted. I wish to return the value of the cell 'above'.

Is this possible?

DingoCC
  • 159
  • 1
  • 2
  • 12
  • 2
    Maybe the `Previous` function https://learn.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-previous-function?view=sql-server-2017 – Dale K Feb 18 '19 at 02:09
  • 3
    If you want to do this in SQL (data source) .. depending on the version you are using.. you could use the LAG function to get "previous" rows data and compare it to current row to find the difference and apply color rules and use that color in your report as a field value. – Harry Feb 18 '19 at 02:23
  • @DaleBurrell I with this would work, it does not: =iif(me.value=previous(me.value), "same","different"). This would permit generic code in every cell. It will work with a named field, but then I'll do the check in SQL instead if I must hard code the field name. – DingoCC Feb 18 '19 at 03:16
  • Unfortunately, there are multiple places where ME isn't recognized (background color, action...). – Hannover Fist Feb 19 '19 at 23:34
  • 1
    @Harry The LAG function is totally awersome. It would allow you to grab other column's information as well as other values within a row, depending on how you specify the Over/Order. – Ethan Keiley Sep 03 '21 at 16:07

0 Answers0