Hi all... again.
I am still having problems setting the backcolor of my matrix cells.
I am able to get a handle on eachcell as the rows and colums have vlaues
associated to them.
E.G.
I have four columns and 4 rows. these will never change.
The code below access the bottom left corner of the matrix and this works.
all i want to do is do 16 if statements to manually set the color.
The problem is when i go to add more if staements. the report jsut doesnt
compile.
How do i add 16 if statements. what is the syntax.
iif(( Fields!PotentialPoints.Value = 25)AND(Fields!PerfPoints.Value = 25),"RED","Yellow")
--
Thanks in advance,
Dave HuntIt may be easier to use VB Switch function.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"DustpanDave" <DustpanDave@.discussions.microsoft.com> wrote in message
news:9723C975-71A4-4379-846B-3EF59E7DB241@.microsoft.com...
> Hi all... again.
> I am still having problems setting the backcolor of my matrix cells.
> I am able to get a handle on eachcell as the rows and colums have vlaues
> associated to them.
> E.G.
> I have four columns and 4 rows. these will never change.
> The code below access the bottom left corner of the matrix and this works.
> all i want to do is do 16 if statements to manually set the color.
> The problem is when i go to add more if staements. the report jsut doesnt
> compile.
> How do i add 16 if statements. what is the syntax.
> iif(( Fields!PotentialPoints.Value = 25)AND(Fields!PerfPoints.Value => 25),"RED","Yellow")
> --
> Thanks in advance,
> Dave Hunt
No comments:
Post a Comment