Trying to get select all in a dropdown from the AS400 to SSRS(Urgent)

105 pts.
Tags:
AS/400
AS/400 reporting
SSRS
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? 

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following