Filter or Group Table data in Detail section by Current Group Item

2 posts, 0 answers
  1. James
    James avatar
    1 posts
    Member since:
    Jan 2013

    Posted 18 Sep 2014 Link to this post

    So I have 2 tables within the Details section of my report.  What I want to do is filter the tables so that it only shows the Data for the Item that is currently "Active" within the group.  I'm not sure if I'm explaining it well enough so here is an example that might clarify it.  

    Let's say you run a Series of Stores broken up into multiple Divisions with each division having X stores with Y Employees.  You want to show the number of Positive and Negative Feedback Results for each employee.  

    You setup the Grouping like so:

    Division Group
        Store Group
            Employee Group

    Within Details you want to show two different sections.  The first section shows the Positive Feedback, and the Second section shows the Negative Feedback. 

    I wasn't sure how to do this with out setting up Tables or CrossTabs so I've opted for tables.  I have setup two of them within the Details section and set the first to Filter on Positive Feedback and the second to filter on Negative Feedback.  What I also need to do is to Filter it by the Employee who is being generated within the group.  

    Is this even possible with Client Side reports?  If so, can someone point me in the right Direction.  I've tried looking in the filters section, but I can't find anything that Deals with the groups specifically.  

  2. Nasko
    Nasko avatar
    944 posts

    Posted 23 Sep 2014 Link to this post

    Hello James,

    You are correct that you need to filter by the employee in the current group. This can be done by assigning the data for the current group/employee to the Table data source. For more information on how to achieve that and samples, please refer to the How to use the ReportItem.DataObject property in expressions help article.


    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Back to Top