all groups > sql server reporting services > february 2006 >
You're in the

sql server reporting services

group:

SetExecutionParameters Multi Value Parameter


SetExecutionParameters Multi Value Parameter Jeff Geer
2/23/2006 12:39:28 PM
sql server reporting services:
How do I set the value for a MultipValue parameter before calling the
SetExecutionParameters web method?

RE: SetExecutionParameters Multi Value Parameter Jeff Geer
2/23/2006 1:44:29 PM
Using the ReportViewer control, you can set the values of a Multi-value
parameter to a string array for a server report.

I can't use this control however, so I'm hoping that the functionality is
exposed somewhere by the report server's web service.



[quoted text, click to view]
RE: SetExecutionParameters Multi Value Parameter Jeff Geer
2/23/2006 2:21:20 PM
OK,

I got it. You add a ParameterValue for each value that you intend to set:

parameters[0] = new ex.ParameterValue();
parameters[0].Name = "CalendarType";
parameters[0].Value = "B";
parameters[1] = new ex.ParameterValue();
parameters[1].Name = "CalendarType";
parameters[1].Value = "C";

This gives the expected results.

[quoted text, click to view]
AddThis Social Bookmark Button