reporting services - SSRS two datasets need to use field from one dataset as a parameter in second? -
reporting services - SSRS two datasets need to use field from one dataset as a parameter in second? -
the issue in field has info 1 record in info set pulled set stored proc (not touchable). using parameter in sec dataset. help appreciated.
add parameter
select parameter visibility hidden
go default values: (screenshot of below)
select "get values query" (and select first dataset , value field)
in dataset 2 filter info new parameter
i.e. select * xyz abc in (@param)
ssrs-2008 reporting-services
Comments
Post a Comment