Code-free report chart with chart series based on multiple columns

[Myth]

Hello,

I have the following data:
Type       Time                                        Value 1       Value 2

Type 1							2013-03-02 13:01:00		0	15
Type 2							2013-03-02 13:01:00		0	8
Type 1							2013-03-02 13:02:00		0	15
Type 2							2013-03-02 13:02:00		0	8
Type 1							2013-03-02 13:03:00		0	15
Type 2							2013-03-02 13:03:00		6	2
Type 1							2013-03-02 13:04:00		0	15
Type 2							2013-03-02 13:04:00		5	3

I wish to draw a line chart with the Time column on the X axis, and 4 lines, being {Type 1-Value1}, {Type 1-Value 2}, {Type 2-Value1}, {Type 2-Value 2},

So far i haven't succeeded in creating this chart. I tried using DataGroupColumn, manually defining series, etc.... but without luck. I am trying to do this from within the standalone report designer, so I can't use code.

Any help is highy appreciated,

Kind regards,
Stijn

[Elian]

Hi Stijn,

The old Chart item does not have the means to create such chart without any code. If you are willing to create it programmatically it will be possible (see Creating Chart Programmatically).

However, your scenario is easily achievable with only a few click using the Graph Wizard and the new Graph item. 

Sample report is attached. The only code in the report is used to serve as data-source and the graph itself is created using the wizard only.

You can also view the following video showing how the wizard is used to create the Graph.

All the best,
Elian
the Telerik team

[Myth]

Hello Elian,

This chart wizard seems to be exactly what I need, however i can't seem to find it in the standalone telerik report designer. Is it possible in the designer, or is possible to create it inside visual studio, but to save the file to a .trdx file? This because my software just loads all .trdx files in a certain folder to show to the user.

Kind regards,
Stijn

[Elian]

Hello Stijn,

In the Standalone Designer, the different types of Graph Wizards are available under the Insert Tab of the ribbon (see attached screen). 
It is also possible to convert existing reports to .trdx, see: How to: Import reports created with the VS Report Designer.
 
All the best,
Elian
the Telerik team

[Myth]

Ah indeed. I hadn't retried that button since installing the latest version of Telerik reports. This is exactly what i need, thanks!

Kind regards,
Stijn

[Riyadh]

I Used Object Data Source to connect data and show it on the  report by Chart  but the problem I want to filter on some things related 
with report how can I update it to be appropriate with the new situation How can you help me if you can
please thanks anyway 

[Nasko]

Hi Riyadh,

To be up to date with the changes in the latest and greatest version of Telerik Reporting, we advise you to replace the now obsolete Chart item with the more advanced Graph item. Using the Graph Wizard you can achieve your scenario effortlessly.

For more information on the Graph item and how to use it please follow the corresponding Graph help articles.
In addition, we have illustrated the Graph item use in our local demos installed by default in C:\Program Files (x86)\Telerik\Reporting <version> and more precisely in the following report definitions:

• Dashboard
• EmployeesSalesSummary
• ProductLineSales

Regards,
Nasko
Telerik