Running Total in Line Chart

[Paul]

Is there a way to apply the RunningValue function to a series in a line chart?  I want tot display the cumulative total at each point.  Importing stored procedures from SRSS reports and would like to not have to modify the Stored procedure.

[Stef]

Hi Paul,

The RunningValue data function is item based, so cannot be applied over series. Please, elaborate on the stored procedure you want to use, the data it returns, the type of chart that will display the data and what totals and where should appear, so we can provide you further suggestions. If the idea is to get calculations based on the data returned by the stored procedure, you can use sqlDataSource component, SelectStatement type of command to extract in temporary table the stored procedure records and manipulate them before passing them to the report, e.g.:

SET FMTONLY OFF;

create table #tmp ([RecursionLevel] int, ManagerID int, ManagerFirstName nvarchar(50), ManagerLastName nvarchar(50), EmployeeID int, FirstName nvarchar(50), LastName nvarchar(50))
INSERT INTO #tmp
exec AdventureWorks.[dbo].[uspGetManagerEmployees] @currentManagerID


SELECT Count(distinct EmployeeID), ManagerFirstName
FROM #tmp
Group by ManagerFirstName

where the connection string is set to AdventureWorks database and @currentManagerID can be 3, 16 etc.

If you need further help on the matter, please send us the requested information, so we can provide you more adequate suggestions.

Greetings,
Stef
the Telerik team