|
Home > Archive > MS SQL Server Reporting Services > October 2005 > RunningValue + Aggregate = ERROR??
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
RunningValue + Aggregate = ERROR??
|
|
| Zean Smith 2005-10-28, 8:23 pm |
| I am trying to do alternative color row for my report,
1. On Table - it works
=iif(RowNumber(Nothi
ng) Mod 2 , "#F9F9F9","#EBEBEB" )
2. On Matrix with Value - it works too
=iif(RunningValue(Fi
elds!Name.Value, CountDistinct, Nothing) Mod 2,
"#EEEEEE", "#FFFFFF")
3. On Matrix with Aggregate function - it DOESN'T WORK
=iif(RunningValue(Fi
elds!OrderAmount.Value, Sum, Nothing) Mod 2, "#EEEEEE",
"#FFFFFF")
=iif(RunningValue(Su
m(Fields!OrderAmount
.Value), CountDistinct, Nothing) Mod
2, "#EEEEEE", "#FFFFFF")
It said scope parameter is not for RunningValue???
| |
| Robert Bruckner [MSFT] 2005-10-29, 8:23 pm |
| The "Nothing" scope is not supported in matrix cells - because otherwise it
is not clear if the RunningValue should run horizontally or vertically
through the matrix cells. The scope has to be a specific matrix row group or
column group.
In your case, it sounds like you want to achieve alternating colors for
matrix rows. Take a look at the following blog article:
http://blogs.msdn.com/chrishays/arc...nBarMatrix.aspx
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Zean Smith" < nospam@nospamaaamail
.com> wrote in message
news:Wv2dnQkV7dBsD__
eRVn-qw@rogers.com...
>I am trying to do alternative color row for my report,
>
> 1. On Table - it works
> =iif(RowNumber(Nothi
ng) Mod 2 , "#F9F9F9","#EBEBEB" )
>
> 2. On Matrix with Value - it works too
> =iif(RunningValue(Fi
elds!Name.Value, CountDistinct, Nothing) Mod 2,
> "#EEEEEE", "#FFFFFF")
>
> 3. On Matrix with Aggregate function - it DOESN'T WORK
> =iif(RunningValue(Fi
elds!OrderAmount.Value, Sum, Nothing) Mod 2,
> "#EEEEEE", "#FFFFFF")
> =iif(RunningValue(Su
m(Fields!OrderAmount
.Value), CountDistinct, Nothing)
> Mod 2, "#EEEEEE", "#FFFFFF")
>
> It said scope parameter is not for RunningValue???
>
>
>
>
|
|
|
|
|