Driving Results in Two Tablix Controls with One Parameter List Selection
In my report, I have two tablix controls; Tablix1, and Tablix2. The Datasets for both controls are SQL Server 2008 stored procedures. Both procedures take the same parameter; 'Region'. The proc parameter is typed the same way in both procs. Tablix1 is configured to DS_CensusBreakOutByRegion (@Region), and Tablix2 is configured to DS_CensusBreakOutRegion_Grouped (@GroupedRegion). Tablix1 returns detail data, and Tablix2 returns a summary. This summary appears at the 'end' of the report. @Region is configured to be visible, and Gets its data from a Dataset called DS_Region. My question is how to 'pass the value of @Region' to the @GroupedRegion parameter configured for the dataset in Tablix2. It seems like I should be able to 'Specify Values' for @GroupedRegion and set the value to @Region (=Parameters!Region.Value). However, when I try to view the report in BIDS, I get the following message: 'The GroupedRegion parameter is missing a value'. Is this one of those things that only works when the report is deployed to the Report Manager, or do I not have the parameters configured correctly? This is a SSRS 2008 Report running against Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) . Thank you for your help. cdun2
December 10th, 2010 3:17pm

If @Region = @GroupedRegion, then Delete the @GroupedRegion report parameter. In your second dataset, map the @GroupedRegion query parameter to @Region. You will need to find the parameters tab on the dataset.Russel Loski, MCT
Free Windows Admin Tool Kit Click here and download it now
December 10th, 2010 4:01pm

That got it! Thank you for your help! cdun2
December 15th, 2010 4:35pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics