Saturday, February 25, 2012

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

No comments:

Post a Comment