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

Splitting report data into multiple charts

2 Answers 148 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Tristan
Top achievements
Rank 1
Tristan asked on 22 Dec 2015, 11:37 AM

I have a simple line chart report, and what I'd like to do is split the data across multiple charts.

I'm using an ObjectDataSource which returns a list of class objects with relevant fields: SampleTime, Value. 

 The chart uses SampleTime as the category and Value as value.

The samples come in at 30 minute intervals, but the charts need to be instanced by date; so two days of data would be 96 data points which would split over two charts. The range of days in the data is arbitrary so it might be 2 days data or it might be 31.

The best I've managed so far is to split the data into different coloured lines on the one chart by adding SampleTime.Date as a series group, but I feel there must be a way to have an arbitrary number of charts on the report, one for each day. In an ideal world the individual charts would populate multiple charts to one report section.

Anyone have any insight or examples to share? I've included an image below that may clarify what I'm looking for.

2 Answers, 1 is accepted

Sort by
0
Accepted
Stef
Telerik team
answered on 25 Dec 2015, 10:39 AM
Hi Tristan,

Please check the example in the Creating a Calendar Report with Telerik Reporting blog post.
Data can be used as a Table/Crosstab/List item's DataSource. 

Once there is a slot per unit e.g. day, you can place Graph items in the Crosstab/Table/List item's cells. Data for Graph items can be set via separate data source component, or by re-using the data associated with the Crosstab/Table/List item - How to use the ReportItem.DataObject property in expressions.

I hope this information is helpful.

Regards,
Stef
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Tristan
Top achievements
Rank 1
answered on 04 Jan 2016, 03:13 PM

In the end I had to create a separate datasource for every single chart as in the Calendar report example. Ugly, but it does work.

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