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: totals in matrix report

Hello,
How can I create a total at the bottom and on the right in a matrix type
report.
Thanks,
Jim.Right click on the column you want to have 'Total' and choose "Sub
total".
Henry
JIM.H. wrote:
> Hello,
> How can I create a total at the bottom and on the right in a matrix
type
> report.
> Thanks,
> Jim.

Q: subtotal of rows in matrix

Hello,
I have a matrix report, how can I sum rows under a column. It seems add
subtotal works for summing of columns not rows.
Thanks,Nver mind. Found it.
"JIM.H." wrote:
> Hello,
> I have a matrix report, how can I sum rows under a column. It seems add
> subtotal works for summing of columns not rows.
> Thanks,
>|||Hey
I've been having the same problem, only with both rows and columns.
The subtotal for the row only grabs the first column's value and th
column subtotal only grabs the first row's value. Could you pleas
explain how you got the subtotals to work? If you can't at least pos
the solution you figured out
Thanks