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

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

1 Answer 350 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
James
Top achievements
Rank 1
James asked on 18 Sep 2014, 06:07 PM
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
            Details.  

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.  




1 Answer, 1 is accepted

Sort by
0
Nasko
Telerik team
answered on 23 Sep 2014, 11:26 AM
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.

Regards,
Nasko
Telerik
 

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.

 
Tags
Report Designer (standalone)
Asked by
James
Top achievements
Rank 1
Answers by
Nasko
Telerik team
Share this question
or