Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CBrammer
Starting Member
7 Posts |
 Posted - 2008-03-12 : 11:19:52
|
| What I have is two reports both with one table. When the first report is rendered, the table is loaded with State county seeds and a percentage, when the percentage is clicked within a given county seed then the counties for that county seed are rendered in the other report, with a percentage for each county.Ok my question is how do I pass the county for a selected county seed, I can bring all of the counties back, but for some reason I can't get just the counties for a given county seed. I get the all of them back with this expression [Vw Dim Worker].[County Name].[All], but I have tried this other expression ="[Vw Dim Worker].[County Name].&[" & Fields!CountyName.Value & "]" and all I get is an error that says A value expression used for the report parameter VwDimCountyName refers to a field. Fields cannot be used in report parameter expressions.I should also mention I am using MDX with SSRS 2005 |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-03-12 : 12:42:47
|
| Are you using a parameter in your stored procedure that do the search for the counties related to specific county? You may need two different stored procedure. |
 |
|
|
CBrammer
Starting Member
7 Posts |
Posted - 2008-03-12 : 15:39:19
|
| No stored procedures, For each report a new dataset is created filtered on the parameters passed from the other report. The MDX is created from the designer, by dragging the fields into the query designer. Is this making sense? |
|
|
|
|
|
|
Passing Parameters