sql server reporting services: Hi,

How can I use RunningValue Aggregate Functions in a chart?
I put "= RunningValue(Fields!Volume.Value, Sum, Nothing)" in the "Chart Data
Values" properties, but it raise this error
message"\\twajkp05\smm\reporting\smm\Vol Bill NRW.rdl The expression for the
chart ‘chart2’ 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 ‘chart2’.".
If I change the Formula into "= RunningValue(Fields!Volume.Value, Sum,
"chart2_CategoryGroup1")", the error message did not appear, but the chart is
blank. How can I resolve this?

Thanks In Advance...

--
Regards,
Jono Indrawijaya
PT eBiz Cipta Solusi - Indonesia

Sorry, RunningValue within charts is not available in RS 2000. It will be
available in RS 2005.

Depending on the target database (SQL Server, Oracle, etc.), the way the
data are stored, and the type of running totals required, you may also be
able to calculate running totals directly in the query and use it in RS
2000. Here is a simple example for the equivalent of our RunningValue( ...,
Sum) done in a SQL query (runs against Northwind):

SELECT
OD1.ProductID,
OD1.OrderID,
MIN(OD1.Quantity) AS Quantity,
SUM(OD2.Quantity) AS ProdRunTotal
FROM [Order Details] AS OD1 JOIN [Order Details] AS OD2
ON OD1.ProductID = OD2.ProductID
AND OD2.OrderID <= OD1.OrderID
GROUP BY OD1.ProductID, OD1.OrderID
ORDER BY OD1.ProductID, OD1.OrderID


-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.


"Jono Indrawijaya" <JonoIndrawijaya@discussions.microsoft.com> wrote in
message news:8CE39C70-A824-4299-873D-2D0038EDDEFF@microsoft.com...
[quoted text, click to view]