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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!