Matrix Master Detail Report
I am trying to create a report that has a group heading and then below this a data band containing a matrix object that displays data related to the group header. I have tried using Master Detail report type, Group Header type report and a Sub Report but I cannot get the matrix object to filter the data displayed based on the group header.
Is this possible and if so how would I do this?
Thanks
Andy
Is this possible and if so how would I do this?
Thanks
Andy
This discussion has been closed.
Comments
I am also having the same issue. Any update on this?
Hello!
A MatrixObject is a component with its own data source (DataSource). When placed within a Master DataBand or GroupHeaderBand, the matrix iterates through all records in its data source from start to finish, unless explicit filtering is specified.
Set the Filter property directly for the MatrixObject:
Select the Matrix control placed within a Master DataBand or under a group header.
In the ‘Properties’ window, locate the Filter property.
Enter a join expression linking the detail table to the master table/group:
[Sales.CategoryID] == [Categories.CategoryID](or using the group field:
[Detail.GroupID] == [Master.GroupID]).FastReport .NET will now filter the detail rows on each iteration through the master table, generating a separate cross-table for each category/group.