RunningValue in Drilldown problem

HI,
We are using RunningValue function to alternate color for displaying rows.
Here is the property value for backgrond color:
=iif(RunningValue(Fields!Row_Date.Value, CountDistinct,Nothing) Mod 2,
"white", "#E4E7E6")
We are having a problem with using that and a drill down at the same time.
The first drill down works fine, but the second does not. Any thoughts?
MichaelI am in the middle of installing the gold bits, so I don';t have books on
line, but we use the rownumber function instead of runningvalue... See if
that works for you.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Michael" wrote:
> HI,
> We are using RunningValue function to alternate color for displaying rows.
> Here is the property value for backgrond color:
> =iif(RunningValue(Fields!Row_Date.Value, CountDistinct,Nothing) Mod 2,
> "white", "#E4E7E6")
> We are having a problem with using that and a drill down at the same time.
> The first drill down works fine, but the second does not. Any thoughts?
> Michaelsql