How to manually set a mutli value parameter on a sub report.

[Durnster]

I am using SSRS 2005.

How do I manually specify a multi value parameter for a sub report, when the
main report has no parameters (ie the sub report parameters are hard coded in
the main report)?

For example, I have a report which shows all sales for a particular date
range. this report has 3 parameters, startdate(date), enddate(date) and
salestype(this is a multivalue parameter set to get the available values from
a query - something like "select distinct salestype from salestypes").

This report is then placed as a subreport, and by right clicking and going
to the properties-->parameters tab, the start and end date parameters are set
to expressions computed based on the current date (so the start date is set
to the previous monday and the end date is set to the previous friday).

Now, if I set the multivalue parameter to a single value (by typing in
"Widgets", for example), then my subreport works fine. But if I try to set
the multiparameter to more than one value (by typing in "Widgets, Thingies"
for example) then I get the following errors:
[rsErrorExecutingSubreport] An error occurred while executing the subreport
‘subreport1’: One or more parameters required to run the report have not been
specified.
[rsParameterValueDefinitionMismatch] The ‘AllowBlank’ property of report
parameter ‘LeadGroup’ is set to false. However, the ‘ValidValues’ property
contains a value that violates the ‘AllowBlank’ property condition.
[rsNone] One or more parameters required to run the report have not been
specified.
[rsErrorExecutingSubreport] An error occurred while executing the subreport
‘subreport2’: One or more parameters required to run the report have not been
specified.
[rsParameterValueDefinitionMismatch] The ‘AllowBlank’ property of report
parameter ‘LeadGroup’ is set to false. However, the ‘ValidValues’ property
contains a value that violates the ‘AllowBlank’ property condition.
[rsNone] One or more parameters required to run the report have not been
specified.
[rsWarningExecutingSubreport] Warnings occurred while executing the
subreport ‘subreport3’.
[rsParameterValueDefinitionMismatch] The ‘AllowBlank’ property of report
parameter ‘LeadGroup’ is set to false. However, the ‘ValidValues’ property
contains a value that violates the ‘AllowBlank’ property condition.
[rsErrorExecutingSubreport] An error occurred while executing the subreport
‘subreport5’: One or more parameters required to run the report have not been
specified.
[rsParameterValueDefinitionMismatch] The ‘AllowBlank’ property of report
parameter ‘LeadGroup’ is set to false. However, the ‘ValidValues’ property
contains a value that violates the ‘AllowBlank’ property condition.
[rsNone] One or more parameters required to run the report have not been
specified.

Is it possible to set a multi value parameter on a sub report?

Thanks in advance.

[vinuthan]

Do set multiple values for a multivalue paramter in a subreport, we need to
pass the value as an array. This can be done by using the Split function in
value expression
Example:=Split("Value1,Value2,Value3", ",")

Hope i have given you an approach. Let me know if this helps.

Rest you can take it forward