all groups > sql server reporting services > september 2005 >
You're in the

sql server reporting services

group:

Runningvalue in graph



Re: Runningvalue in graph Robert Bruckner [MSFT]
9/21/2005 5:16:41 PM
sql server reporting services: 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.


[quoted text, click to view]

Runningvalue in graph Jack Nielsen
9/21/2005 11:42:21 PM
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

Re: Runningvalue in graph Jack Nielsen
9/22/2005 1:23:21 PM
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...
[quoted text, click to view]

Re: Runningvalue in graph Robert Bruckner [MSFT]
9/24/2005 7:33:57 PM
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.

[quoted text, click to view]

Re: Runningvalue in graph john
12/5/2005 12:34:02 PM
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?

[quoted text, click to view]
Re: Runningvalue in graph john
12/5/2005 12:41:02 PM
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.

[quoted text, click to view]
AddThis Social Bookmark Button