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.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Main report has no parameter, but subreport does

Author  Topic  rrh Starting Member 1 Post Posted - 2009-03-30 : 11:41:25 I am using SSRS 2005 to make a report. I have a main report that has no parameters with a stored procedure that returns a set of data. The main report has a subreport w/ a parameter. I want to use one of the fields from the dataset in the main report as a parameter to be passed into the subreport. From the main report, I have tried going to the properties for the subreport and fill in the parameters tab and putting “Fields!field_name.Value” as the Parameter Value. It will save, but doesn’t pass through the value from “Fields!field_name.Value” into the subreport as the parameter. The report properties does have a Code tab that will take VB code. How to do I make the main report pass a field through to the subreport as a parameter? Any help would be appreciated. Thanks!