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

Filter Table data by group scope

1 Answer 35 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Heorhi
Top achievements
Rank 1
Heorhi asked on 03 Jun 2020, 02:38 PM

Hi,

I spent hours trying to filter Table data in GroupFooterSection. We need to filter it by group scope, how can we do this? Filter like Fields.code = Exec('group',Fields.code) didn't work. Many thanks in advance.

 

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 08 Jun 2020, 09:48 AM

Hello Heorhi,

From the screenshot and the visible field names, I assume that you use different data sources for the Report and the Table. If so, in the Filtering Expression you may use the ReportItem.DataObject Global Object to access the group scope, for example:

=Fields.code	=	 =ReportItem.DataObject.code

I have attached a sample report demonstrating the approach.

If the Table and the Report utilize the same DataSource, you may use Bindings to bind the Table DataSource to the data source of its parent - Binding to data from the parent data item, that would be the report group, which will automatically filter the records passed to the Table to the records in the group, hence the filtering will occur naturally.

Regards,
Todor
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
Tags
General Discussions
Asked by
Heorhi
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or