Single Series Graph, and filtering

[Joel]

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.

 

 

[Stef]

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:

• Building the Graph - Connecting to Data and How to: Create Bar Chart for example;
• Filtering the data - Filtering and How to use the ReportItem.DataObject property in expressions

Let us know if you have any further questions.

Regards,
Stef
Telerik