Crosstab - Line Chart in Cell

2 posts, 0 answers
  1. Brian
    Brian avatar
    36 posts
    Member since:
    Mar 2016

    Posted 07 Jul 2016 Link to this post

    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.

  2. Nasko
    Nasko avatar
    1071 posts

    Posted 08 Jul 2016 Link to this post

    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 help articles.

    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
Back to Top