Runningvalue in graph

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.dkIs 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
>|||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
> >
> >
>|||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
>> >
>> >
>>
>|||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
> >> >
> >> >
> >>
> >>
> >
> >
>
>|||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
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
> >