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

7 posts, 1 answers
  1. Myth
    Myth avatar
    54 posts
    Member since:
    Jan 2010

    Posted 02 Mar 2013 Link to this post

    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
  2. Elian
    Admin
    Elian avatar
    435 posts

    Posted 06 Mar 2013 Link to this post

    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

    See what's new in Telerik Reporting Q1 2013. Register for the March 4 webinar to witness the impressive new visualizations in Telerik Reporting. Just for fun, 10 webinar attendees will be randomly selected to win a Telerik T-shirt and a $50 Gift Certificate to ThinkGeek. Register now! Seats are limited!

  3. DevCraft banner
  4. Myth
    Myth avatar
    54 posts
    Member since:
    Jan 2010

    Posted 06 Mar 2013 Link to this post

    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
  5. Answer
    Elian
    Admin
    Elian avatar
    435 posts

    Posted 07 Mar 2013 Link to this post

    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

    Telerik Reporting Q1 2013 available for download with impressive new visualizations. Download today from your account.

  6. Myth
    Myth avatar
    54 posts
    Member since:
    Jan 2010

    Posted 07 Mar 2013 Link to this post

    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
  7. Riyadh
    Riyadh avatar
    3 posts
    Member since:
    Oct 2013

    Posted 17 Oct 2013 Link to this post

    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 
  8. Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 22 Oct 2013 Link to this post

    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:

    Regards,
    Nasko
    Telerik

    Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.

Back to Top
DevCraft banner