I have report in SSRS and there is a formatting requirement that I am not able to take care of
GroupName Leads1 Leads2 Leads3
My issue is when there is an increase in this count for any of the member then I need to change the background color of the ColumnName at the Group level so in this case for mem1 couint increases from 2 to 4 from then bg color of leads2 column
should be RED Leads 3 would be red bcoz the count increases from 3 to 5. Similarly I need to check for all the records in my group and set the bg color property to RED for that column whose members shows increasing behavior when compared
to previous values.
I tried applying the expression to bgcolor property of the column name but it just cjhecks for the values in the first row. I some how need to write an expression that would be applied to all the rows in a group.
View Complete Post