SSRS - Multiple Parameters - VisualCron - Forum

Community forum

Lynchie
2017-03-20T10:43:56Z
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.
Support
2017-03-20T19:54:13Z
Can you attach some screenshots so we can track where the message comes from?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Lynchie
2017-03-21T15:14:22Z
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.
Support
2017-03-22T10:00:33Z
No, you need to split the parameters. Cannot use ampersand.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top