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

Crosstab - Line Chart in Cell

1 Answer 77 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Brian
Top achievements
Rank 1
Brian asked on 07 Jul 2016, 12:03 PM

I am attempting to replicate the Sales Dashboard demo report in that you have a line chart within the pivot table.

I have a simple dataset that has my categories of items as row data and the months as columns. The pivot table is reporting all data properly.

I create a line chart outside of the pivot table and it displays correctly in that all categories are plotted on the chart. I then move that chart into cell within the pivot table.

Upon preview, for each row, the chart is displayed but shows all categories rather then the data for the category row. 

It appears that there is no "filter" being passed into my chart. I have attempted to review how you did this in your example but can't seem to figure it out.

Would it be possible to get some screen shots showing what needs to be done to pass the current rows "ID" into my chart to filter it?

Note that going back and forth between my report and your sample causes the properties windows to collapse so it is easy to loose where you are looking in the properties section.

Any help would be really appreciated. Thanks.

1 Answer, 1 is accepted

Sort by
0
Nasko
Telerik team
answered on 08 Jul 2016, 10:03 AM
Hello Brian,

The key point is to bind the nested chart to the data object of the parent. This screenshot shows how this is done in the Sales Dashboard sample.
For more information on the topic, please refer to the Bindings and How to use the ReportItem.DataObject property in expressions  articles.

Regards,
Nasko
Telerik by Progress
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
Tags
Report Designer (standalone)
Asked by
Brian
Top achievements
Rank 1
Answers by
Nasko
Telerik team
Share this question
or