In SSRS 2008 I have 10 columns, and the data is grouped up based on column one (lets call it employee number), and has multiple rows in each group, ordered by a weekly date with the most recent week is at the top. In column 10 of the group header row, I would like to check if column 10 on the first row contains the value 1 and if so, set a red box/indicator in that header column 10. If any of the other rows below the first contain a 1 then return amber otherwise remain uncoloured.
Is this possible?
Have you tried using the FIRST function in the expression field of the BackgroundColor property?