This is a migrated thread and some comments may be shown as answers.

Running Total in Line Chart

1 Answer 58 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Paul
Top achievements
Rank 1
Paul asked on 07 Feb 2013, 02:48 PM
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.

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 12 Feb 2013, 03:00 PM
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

HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

Tags
General Discussions
Asked by
Paul
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or