CONDITIONAL FORMAT IN SUBTOTAL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Estefania - 31 Mar 2005 09:27 GMT

Hello!

I'm trying aply conditional format in subtotal fields belongings to a Matrix. But it seems it doesn't work. I'd like to change the background color each two rows , I'm using something like that:

=iif(RowNumber(Nothing) mod 2=1,"Black","White")

Anyone Knows why it doesn't work rowNumber in subtotal fields or any new idea?

Reply to this Message

Timm - 31 Mar 2005 17:01 GMT

I haven't tried this yet, but from using Report Services so far... the only
functions recognized in expressions for fields and such are global VB
Functions. So I think that's why RowNumber doesn't work, but I could be
wrong.

Maybe you could try putting your subtotals in a different matrix with a
query that actually calculates the subtotals... and also with said query add
the row numbers (using identity or whatnot) and use those for your formatting
expression.

> Hello!
>
[quoted text clipped - 3 lines]
>
> Anyone Knows why it doesn't work rowNumber in subtotal fields or any new idea?

Reply to this Message