Hello,
In a crosstab, how do I change the background color of a field based on another field.
For example: Table(Year, Label, Value, State)
The crosstab is: Column=Year, Row=Label, Field=Value
2008 2009 2010
Label1 val1 val2 val3
Label2 val4 val5 val6
The formula on the field {Table.Value} is:
If {Table.State} = 0 Then crRed Else crBlue
Thank you for your help
In a crosstab, how do I change the background color of a field based on another field.
For example: Table(Year, Label, Value, State)
The crosstab is: Column=Year, Row=Label, Field=Value
2008 2009 2010
Label1 val1 val2 val3
Label2 val4 val5 val6
The formula on the field {Table.Value} is:
If {Table.State} = 0 Then crRed Else crBlue
Thank you for your help