Reporting Services Conditional formating

• Dave2906

  Old Hand

  Points: 309

  More actions

  November 26, 2008 at 5:16 am

  #203497

  Here is what I am trying to achieve: -

  I have a data set that contains a list of values, I am trying to conditionally format the top 2 and minimum 2 values, changing the font color, I have managed to use the Max and Min functions to achieve the result for the max and min values but am struggling to come up with a way to format the second values, any suggestions would be greatly appreciated.

  I used the following as a starting point (SalesOrderDetail is my dataset): -

  =IIF(Me.Value = Max(Fields!LineTotal.Value, "SalesOrderDetail"), "Red", "Black")

  Many Thanks

  David.

• dva2007

  SSCertifiable

  Points: 7707

  More actions

  December 1, 2008 at 4:10 am

  #905460

  please refer to the following link about all color changes in RS. U can see lots of innovative stuff from this link.

  http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

  regards,

  vijay