Filter Table data by group scope

[Okov]

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.

 

[Todor]

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