Q:matrix rownumber?

Hello,
In the matrix representation I am using this to show different color in each
line, it says invalid running value.
=iif(RowNumber("DataSource1") mod 2 = 1, "WhiteSmoke", "LightCyan")
what is problem?
Thanks,
Jim."JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:9CD04C65-DBDD-4600-9C03-BF7A833BFB9C@.microsoft.com...
> Hello,
> In the matrix representation I am using this to show different color in
each
> line, it says invalid running value.
> =iif(RowNumber("DataSource1") mod 2 = 1, "WhiteSmoke", "LightCyan")
> what is problem?
> Thanks,
> Jim.
You need to remove the "= 1" part, so your statement looks more like this:
=iif(RowNumber(Nothing) Mod 2, ""WhiteSmoke", "LightCyan")
You might have to exchange "Nothing" with your "Datasourc1", but try to use
this statement first.
Kaisa M. Lindahl|||no it did not work
"Kaisa M. Lindahl" wrote:
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:9CD04C65-DBDD-4600-9C03-BF7A833BFB9C@.microsoft.com...
> > Hello,
> > In the matrix representation I am using this to show different color in
> each
> > line, it says invalid running value.
> > =iif(RowNumber("DataSource1") mod 2 = 1, "WhiteSmoke", "LightCyan")
> > what is problem?
> > Thanks,
> > Jim.
> You need to remove the "= 1" part, so your statement looks more like this:
> =iif(RowNumber(Nothing) Mod 2, ""WhiteSmoke", "LightCyan")
> You might have to exchange "Nothing" with your "Datasourc1", but try to use
> this statement first.
> Kaisa M. Lindahl
>
>|||Kaisa,
one more point, my case is working when it is table presentation. it does
not work for matrix representation. Is RowNumber valid if it is matrix?
Thanks,
Jim.
"Kaisa M. Lindahl" wrote:
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:9CD04C65-DBDD-4600-9C03-BF7A833BFB9C@.microsoft.com...
> > Hello,
> > In the matrix representation I am using this to show different color in
> each
> > line, it says invalid running value.
> > =iif(RowNumber("DataSource1") mod 2 = 1, "WhiteSmoke", "LightCyan")
> > what is problem?
> > Thanks,
> > Jim.
> You need to remove the "= 1" part, so your statement looks more like this:
> =iif(RowNumber(Nothing) Mod 2, ""WhiteSmoke", "LightCyan")
> You might have to exchange "Nothing" with your "Datasourc1", but try to use
> this statement first.
> Kaisa M. Lindahl
>
>|||RowNumber is usable within a matrix, but its a scoping issue
that you're running into. Here's a description of how to do
what you want:
http://blogs.msdn.com/chrishays/archive/2004/08/30/223068.aspx
Also, you do not need to remove the "= 1". It works just fine with
that in there, however it is unnecessary.
-Rob
"JIM.H."
> Kaisa,
> one more point, my case is working when it is table presentation. it does
> not work for matrix representation. Is RowNumber valid if it is matrix?
> Thanks,
> Jim.
> "Kaisa M. Lindahl" wrote:
> > You need to remove the "= 1" part, so your statement looks more like
this:
> >
> > =iif(RowNumber(Nothing) Mod 2, ""WhiteSmoke", "LightCyan")
> >
> > You might have to exchange "Nothing" with your "Datasourc1", but try to
use
> > this statement first.
> >
> > Kaisa M. Lindahl

Q:conditional formating

Hello,
I am trying to color negative detail lines with the following.
=iif((Fields!Amt1.Value-Fields!Amt2.Value)<0,"Red","Black")}
It is working if the value is not zero. Some 0.00 values are black but some
of them are red. What is problem?
Jim.Hi Jim
I think the problem is because you haven't specified the text color for
the result value zero.
You can try specifying the condition as "<=0" if you want the zero
values in red like
=iif((Fields!Amt1.Value-Fields!Amt2.Value)<=0,"Red","Black")
Else if you want zero values in black you can try
=iif((Fields!Amt1.Value-Fields!Amt2.Value)>=0,"Black","Red")
Hope this solves your problem
Regards
Prathima.C
JIM.H. wrote:
> Hello,
> I am trying to color negative detail lines with the following.
> =iif((Fields!Amt1.Value-Fields!Amt2.Value)<0,"Red","Black")}
> It is working if the value is not zero. Some 0.00 values are black
but some
> of them are red. What is problem?
> Jim.|||I did that but it did not change anything. Some of zeros are blank, some are
red. Is there any precession issue?
"prathima.chandramouli@.gmail.com" wrote:
> Hi Jim
> I think the problem is because you haven't specified the text color for
> the result value zero.
> You can try specifying the condition as "<=0" if you want the zero
> values in red like
> =iif((Fields!Amt1.Value-Fields!Amt2.Value)<=0,"Red","Black")
> Else if you want zero values in black you can try
> =iif((Fields!Amt1.Value-Fields!Amt2.Value)>=0,"Black","Red")
> Hope this solves your problem
> Regards
> Prathima.C
>
>
>
> JIM.H. wrote:
> > Hello,
> > I am trying to color negative detail lines with the following.
> > =iif((Fields!Amt1.Value-Fields!Amt2.Value)<0,"Red","Black")}
> > It is working if the value is not zero. Some 0.00 values are black
> but some
> > of them are red. What is problem?
> > Jim.
>