I am have troble trying to get a select all fuction using AS/400 data on Mircosoft reporting services. Normally I know you just go into the parameter and click multivalued but that is not working. I have create a Stored procedure to use the calender feature for date I don't know if there is a way I could use a store procedure to get the select all function to work.
Because I am using the AS/400 I need to use a ? to create parameters in SSRS. Then when I don't a select all in a drop down it says this error message.
"Cannot add Multi Value query parameter '?' for data set 'Boston' because it is not supported by the data extension"
I have tried a lot. anyone know how to fix it and any suggestions?