Morning,

Using the SSRS Task to export to CSV, how do you cater for multiple selection dropdowns in the parameters.

I have tried doing it much the same way as it works using a HTTP GET by concatenating the string using ampersands but this doesn't seem to work in the VisualCron task as it complains about no default value being selected.

Cheers.

Can you attach some screenshots so we can track where the message comes from?

---

Hi,

After setting the parameter as "Motor Trade&Brand=Autosaint&Brand=Ladybird" it returns the following error when the task is ran:

Exception in Task: This report requires a default or user-defined value for the report parameter 'Brand'. To run or subscribe to this report, you must provide a parameter value. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportParameterValueNotSetException: This report requires a default or user-defined value for the report parameter 'Brand'. To run or subscribe to this report, you must provide a parameter value.

However if I do a HTTP Task and write the URL as follows:

http://xxxxx.co.uk/Repor...d=Render&Brand=Motor  Trade&Brand=Autosaint&Brand=Ladybird&rs:Format=csv

This will download the report recognising that I want 'Motor Trade', 'Autosaint' and 'Ladybird' from my 'Multiple' Selection Parameter from the report, how can we mimic this using you're parameters function in the SSRS Task.

I haven't used screenshots because all I'm going to be screenshotting is the above.

Cheers.

No, you need to split the parameters. Cannot use ampersand.

---