How to filter rows in table item in a report having its own data souce

[Edward]

Could you give example of how to set the Filter property of a table in a report which has its own datasource set (i.e. the table does), so that the rows of the table can be filtered by a dataitem from the report's own datasource.  (So there is two datasources, one for the report and one for the table in the report, and want to filter the table rows by a field value from the report's main datasource.)

[Silviya]

Hello Edward,

You can filter the table datasource based on the main report's datasource by using =ReportItem.DataObject (check this screen shot for reference - https://www.screencast.com/t/e0iHs0Bn). From here on, you can define the field you would filter on, i.e.:

=ReportItem.DataObject.FieldFromMainReport

More information is available in the following help articles as well:
- How to: Add filtering to Table item and Crosstab item
- How to use the ReportItem.DataObject property in expressions

Regards,
Silviya
Progress Telerik

[Edward]

NOTE:

The syntax used was:
= Fields.attributes.parentglobalid = = ReportItem.DataObject.attributes.globalid

For definition purpose, referencing the datasource of the table starts with Fields, whereas referencing the datasource of the main report starts with ReportItem.DataObject.  Because my data had additional key tags in the json structure, I had to add 'attributes', but the strategies are essentially same.