Single Series Graph, and filtering

2 posts, 0 answers
  1. Joel
    Joel avatar
    166 posts
    Member since:
    Oct 2006

    Posted 14 Apr 2015 Link to this post

    I am a long time Telerik Reporting user, but this is my first attempt at graphs.  Any assistance is appreciated.

     

    I have 2 datatables being passed to my report via a dataset.  table(0) populates the main purpose of the existing report, and is grouped with approx 200 pages of data.  I now need to add a graph to the GroupHeaderSection of the report, which I have done via the Graph Wizard.  table(1) contains the graph datasource and a sample is posted below.

     

    Dim mytable As New DataTable
    mytable.Columns.Add("jobcode", String.Empty.GetType())
    mytable.Columns.Add("labels", String.Empty.GetType())
    mytable.Columns.Add("Count", GetType(Integer))
     
    mytable.Rows.Add(New Object() {"Job 93001", "20-30", 4})
    mytable.Rows.Add(New Object() {"Job 93001", "30-40", 3})
    mytable.Rows.Add(New Object() {"Job 93001", "40-50", 27})
    mytable.Rows.Add(New Object() {"Job 93001", "50-60", 2})
    mytable.Rows.Add(New Object() {"Job 93001", "60-70", 1})
    mytable.Rows.Add(New Object() {"Job 93002", "20-30", 3})
    mytable.Rows.Add(New Object() {"Job 93002", "30-40", 6})
    mytable.Rows.Add(New Object() {"Job 93002", "40-50", 7})
    mytable.Rows.Add(New Object() {"Job 93002", "50-60", 8})
    mytable.Rows.Add(New Object() {"Job 93002", "60-70", 2})

     

    1.  The graph is treating each row in the datatable as a series.  How do I force this to a single series for color and alignment purposes?

    2.  How do I filter between the 2 datasets.  In the main report, Fields.jc is the group control.  I need to filter the graph to only show the appropriate jobcode based off of the groupheadersection.

     

    Thank you.

     

     

  2. Stef
    Admin
    Stef avatar
    3053 posts

    Posted 17 Apr 2015 Link to this post

    Hello Joel,

    Please check the attached video illustrating the settings required to add a Graph item in a group section, and filter its data based on a field from the parent data scope. In the example, we use the approaches elaborated in:

    Let us know if you have any further questions.

    Regards,
    Stef
    Telerik
     

    See What's Next in App Development. Register for TelerikNEXT.

     
  3. DevCraft banner
Back to Top