sql server - Pass field from one dataset to another dataset as parameter In SSRS 2008 R2 -
i have scenario 1 of data-set returns multiple records. have implemented grouping in report display each record data set on different page.
now have dataset loads data using fields dataset1 parameter. means need assign fields dataset1 dataset2 parameter each record.
for single record, can assign values dataset1 report parameter , use our dataset.
but in case, parameter holds value 1st record , passes every page or group.
how can achieve this?
i had same problem, value first record in parent report dataset each subreport record.
in case, resolution remove hidden parameter using in parent report. default value assigning parameter results query.
i went properties of subreport, selected parameters , in value dropdown assigned parent report parameter, switched field name of parent report dataset field pass value subreport parameter.
hope helps.
Comments
Post a Comment