SSRS 2005: Filter Nested Table within a List
- by Even Mien
In SQL Server Reporting Services 2005, how can I filter a nested table within a list?
I have 2 datasets. The first, datasetHeader, contains one row per account. The second, datasetDetails contains multiple rows per account.
Control: Dataset name
List: datasetHeader
Table: datasetDetails
The table is placed within the list. When I attempt to filter on the table, I get fields from datasetHeader instead of datasetDetails.
Previously I had the table within a subreport, and I had that working by using parameters; however, I needed to pull it into the main report because of the implied KeepTogether=true property for subreports that was causing undesired pagination.