Format Group based on detail row value?

• Veronka

  Default port

  Points: 1425

  More actions

  May 26, 2009 at 12:37 pm

  #205274

  Hi,

  I have a simple table report with 1 group. Based on a field in the detail section, I would like to color the group values(header) in red/black.

  For example

  - if there is a row in detail section which has IsNew = 1 then color detail row and corresponding header(group) row to red.

  How can I do this in SSRS 2005?

  Thanks.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  May 26, 2009 at 3:13 pm

  #1000218

  Assuming that there are 2 values for IsNew (1, 0) you could use:

  =IIF(Max(Fields!IsNew.value) = 1, color, other_color)

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Veronka

  Default port

  Points: 1425

  More actions

  May 27, 2009 at 9:55 am

  #1000768

  Excellent! ... so simple!

  Thank you!