I found a new thread where Robert Bruckner answers this question. The thread
is titled RunningValue in a chart - scope issues. My issue was using a
category group rather than a series group. Works great now.
"john" wrote:
> I am using RS 2005 but still can't get the running value function to work.
> The expression doesn't cause any errors - the totals simply don't "run".
> They are plotted as single values. Any thoughts?
>
> "Robert Bruckner [MSFT]" wrote:
>
> > Yes, for RS 2000 you should perform the calculation inside the query or in a
> > stored procedure.
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Jack Nielsen" <nospamjackd@jackd.dk (Fjern nospam)> wrote in message
> > news:%23DFrJf2vFHA.3236@TK2MSFTNGP14.phx.gbl...
> > > Yes it is RS 2000, how is it possible to do make a chart where the months
> > > are added to eachother each month, a temporary table ?
> > >
> > >
> > > "Robert Bruckner [MSFT]" <robruc@online.microsoft.com> skrev i en
> > > meddelelse
> > > news:%23LFJprwvFHA.596@TK2MSFTNGP12.phx.gbl...
> > >> Is this RS 2000? RunningValues in charts are not supported in RS 2000,
> > > only
> > >> in RS 2005.
> > >>
> > >> -- Robert
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > >>
> > >>
> > >> "Jack Nielsen" <no_spam jack.nielsen@get2net.dk> wrote in message
> > >> news:ehm$ZVvvFHA.252@TK2MSFTNGP09.phx.gbl...
> > >> > g:\surround\reportingservice\c5\c5 standard rapporter\Finans
> > >> > rapport.rdl
> > >> > The
> > >> > expression for the chart 'chart1' has a scope parameter that is not
> > > valid
> > >> > for RunningValue, RowNumber or Previous. The scope parameter must be
> > > set
> > >> > to
> > >> > a string constant that is equal to the name of a containing group
> > >> > within
> > >> > the
> > >> > matrix 'chart1'.
> > >> >
> > >> > I get that error when trying to make a running value in a chart.
> > >> >
> > >> > I need to have the months summed together month for month to show the
> > >> > progress between different fiscal years and budget, now it shows each
> > >> > months
> > >> > values.
> > >> >
> > >> > this is the expression
> > >> >
> > >> > =RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
> > >> > Chart1 is the name of the chart, I also tried with the
> > >> > chart1_CategoryGroup1
> > >> > in the region value but same result !
> > >> >
> > >> > Jack
> > >> >
> > >> >
> > >> >
> > >> >
> > >> > --
> > >> > Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> > >> > Den har indtil videre sparet mig for at få 45077 spam-mails.
> > >> > Betalende brugere får ikke denne besked i deres e-mails.
> > >> > Hent gratis SPAMfighter her:
www.spamfighter.dk > > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >