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

RunningTotal (for the birds)

How do I solve this RDL chart problem?

A bird watcher records the date each time he spots a new type of bird ('NewBird'). Likewise, he records the date of each time he spots a previously known type of bird ('OldBird'). Like this:

SpotDate Event
01/01/07 NewBird
01/01/07 NewBird
01/01/07 NewBird
01/02/07 OldBird
01/02/07 NewBird
01/02/07 OldBird
01/06/07 NewBird
01/06/07 OldBird
01/06/07 OldBird

I want to make an RDL chart that shows a running total of 'NewBird' to 'OldBird' along the date timeline. I am using SQL suite 2K5. I figure my "Category" field should be 'SpotDate', my series field should be 'Event,' and my "Data" field should be some kind of "=RunningTotal(Event, ?)". Is this correct?

And for that matter, how do I convince the RDL chart to include the elapsed time (the missing days between Jan 1, and Jan 6 in the plot)?

Ok, it seems the answer (mostly) to my own question is this:

1) Create a select statement that provides the daily total (e.g. called "Tally") grouped by SpotDate and Event.

2) In the chart, add the SpotDate to the category, the Event to the series, and the "Tally" as the value

3) Edit the "Tally" properties so that its 'value' field shows '=RunningValue(Fields!Tally.Value, Sum, "chart1_SeriesGroup1")

Thats it! The name "chart1_SeriesGroup1" was chosen simply to match the auto-generated name Visual Studio gave to the "Event" series (you can find or edit this name by selecting the 'data' tab on chart properties. One final piece of advice: do not "add" a new dataset field that contains a "RunningValue" calculated value...it causes Visual Studio to crash every time you view a chart (whether or not you used it on the chart).

So now my only remaining issue, is the need to convince the RDL chart to include the elapsed time (the missing days between Jan 1, and Jan 6 in the plot) that I showed as example data earlier.

|||

> need to convince the RDL chart to include the elapsed time (the missing days between Jan 1, and Jan 6 in the plot)

Set the x-axis to use scalar mode and make sure the category grouping expression returns DateTime objects (not data values as strings).

For more information, you may want to read the following section of a technical article on SSRS charts: http://msdn2.microsoft.com/en-us/library/aa964128.aspx#moressrscharts_topic3

-- Robert