Geek Answers Handbook

Ssrs 2008 passing parameter list to subtitle

I have a report in which the user can select several items in the list for one of the parameters. By clicking on the report, an auxiliary report opens with the parameters transferred to the sub-report. If only one item is selected, this works fine. If several elements are selected, then only one element in the parameter list is transferred to the sub-report.

The parent report works fine, only the first element is displayed in the sub-report. I am using SSRS 2008 R2. How can I make the sub-report accept all elements for the passed parameter?

+4
source share
2 answers

, :

  • , .
  • , [@paramName], "=Parameters!ParamName.Value(0)", .
  • subreport , / .
  • , , =Split(join(Parameters!ParamName.Value,","),","), , , .

, , .

+11

sql , ssrs. mmarie, (= Split (join (Parameters! ParamName.Value, "," ), "," )), . - WHERE '%,' + subreport_item + ',%' LIKE ',' + parent_report_multiple_parameters + ',' ...

0

More articles:


All Articles