SSRS - Inspecting first row

0
votes

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?

Many thanks

1
sql-serverreporting-servicesssrs-2008reporting
Please add information as to how the groups are formed and what the naming of each layer are. – Jacobm001
Hi Jacobm001, I'm unsure what a layer is. The groups are formed based on a value of column 1, which as mentioned we are calling Employee Number. Also mentioned is that all the rows in each grouping is organised by date with the most recent at the top. I'm unsure what else needs to be added to this? – RobLW

1 Answers

0
votes

Have you tried using the FIRST function in the expression field of the BackgroundColor property?