SSRS 2005: Filter Nested Table within a List

Posted by Even Mien on Stack Overflow See other posts from Stack Overflow or by Even Mien
Published on 2010-05-13T17:47:43Z Indexed on 2010/05/23 2:30 UTC
Read the original article Hit count: 698

Filed under:

ssrs-2005

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.

Related posts about ssrs-2005

Error in Visual Studio 2008 with SSRS 2005 report projects

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anyone found a good workaound for opening or editing an SSRS 2005 report project with Visual Studio 2008 yet? Will the SQL server 2008 tools be the migration path for these report projects in the future? I really dont want to have to keep VS2005 installed forever just to update SSRS reports… >>> More
SSRS 2005 tabs/newline characters display in table

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How can i get a column in an SSRS 2005 report to render control chars like new lines and tabs? For example: SELECT VW.System_name + CHAR(13) + CHAR(9) + ' > ' + VW.PTS_NAME + CHAR(13) + CHAR(9) + CHAR(9) + ' > ' + VW.FEED_NAME as Name In SSRS (and SSMS Results to Grid Mode) table… >>> More
SSRS 2005 - Cascading parameters and default value update problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a report with cascading parameters. The first parameter is Finanical Period Type, being either Month or Week. The second parameter is a list of either financial months or weeks depending on what was selected for the first parameter. This all works well and selecting a series of different Financial… >>> More
How do I convert an INT into HH:mm:ss using SSRS 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Ok I need to display total talk time of an agent that is coming into SRSS 2005 from SQL 2005 as an INT. For the life of me I cannot figure out what combination of expression editing or format editing I need to use. For the detail portion I can use: =DATEADD("s", SUM(Fields!Talk_Time.Value), CDate("00:00")) And… >>> More
How to pass Multivalued parameters through URL in SSRS 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I have main matrix report and I want to navigate my sub report from main report by Jump To URL:(Using below JavaScript function) method. ="javascript:void(window.open('http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fKonsolidata_Data_Exporting_Project%2fEXPORT_REPORT_TEST&rs:Command=Render&RP_cntry="+Fields… >>> More

Developer IT