views:

164

answers:

0

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.

related questions