I've SSRS 2005 Report with 7 subreports.
Toplevel report runs the query and returns recordset.
RegionID CustID orderID OBID State City Name
69 1230 4565 75855 NY NYC Sam
Now i need to pass these values in subreports's query as parameter
select * from Region where regionID = @RegionId (in my case it shud get 69 from upper record set.)
Likewise there are 6 more subreports where i need to pass above values as parameter.
Any suggestions would be very helpful.
View Complete Post