Alternate row in diffrerent colors

Hi,
I wish to change the back colour for alternate rows in a report (say Table).
I haven't found anything that tells me the current-rownum. The RowNum seems
more like a row-count. Please help!!
Thanks in advance,
Regards,
DattaTo have alternating colours in a table, use this formula
=iif(RowNumber(Nothing) Mod 2, "Gainsboro", "White")
A slightly more refined version can be found in Adlai Maschiach's blog:
http://dotnetjunkies.com/WebLog/adlaim/archive/2004/08/29/23594.aspx
This is the way to do it if you want to control the alternating colours in a
table with groups, as the first one will not take groupings into
consideration.
To do it in a matrix, you need to do it like Chris Hays writes
http://blogs.msdn.com/chrishays/archive/2004/08/30/GreenBarMatrix.aspx
Kaisa M. Lindahl Lervik
"Datta" <Datta@.discussions.microsoft.com> wrote in message
news:5FC4A7F0-B950-4F0C-A726-D383AC381960@.microsoft.com...
> Hi,
> I wish to change the back colour for alternate rows in a report (say
> Table).
> I haven't found anything that tells me the current-rownum. The RowNum
> seems
> more like a row-count. Please help!!
> Thanks in advance,
> Regards,
> Datta

Alternate Bar Chart Colours

Hi all,
I am using a simple bar chart based on 1 set of data points. Currently each
bar is the same colour, I would like all the bars to be different colours
and the legend to reflect this. Is this possible? If so, any tips would be
appreciated.
Kind Regards
TazI think this is what you want:
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
Steve MunLeeuw
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:%23ipW8uQ0GHA.4580@.TK2MSFTNGP05.phx.gbl...
> Hi all,
> I am using a simple bar chart based on 1 set of data points. Currently
> each bar is the same colour, I would like all the bars to be different
> colours and the legend to reflect this. Is this possible? If so, any tips
> would be appreciated.
> Kind Regards
> Taz
>|||Exactly what I was looking for.
Thank you very much!
Taz
"Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
news:%233RNSzT0GHA.4044@.TK2MSFTNGP04.phx.gbl...
>I think this is what you want:
> http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
> Steve MunLeeuw
> "Tarun Mistry" <nospam@.nospam.com> wrote in message
> news:%23ipW8uQ0GHA.4580@.TK2MSFTNGP05.phx.gbl...
>> Hi all,
>> I am using a simple bar chart based on 1 set of data points. Currently
>> each bar is the same colour, I would like all the bars to be different
>> colours and the legend to reflect this. Is this possible? If so, any tips
>> would be appreciated.
>> Kind Regards
>> Taz
>sql