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 was causing undesired pagination.