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