This is a migrated thread and some comments may be shown as answers.

MultiValue Parameter Problem

8 Answers 566 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

Tom Harkness asked on 09 Dec 2010, 07:58 PM

I had done some reports for industrial production in the Q3 2009 release. I had no issues using MultiValue parameters and passing it so that the customer could look at multiple items in a single report if needed. I am updating and doing some new reports and have found that in the Q3 2010 release the multivalue continually throws me a error but not if the MultiValue is set to False ( it runs fine then). This is happening after upgrading the reports from the old version. If I go back to the old version, they run fine.
I am getting the following error:

Cannot perform '=' operation on System.String and System.Object[]

I checked the documentation and see nothing new for setting Multivalue parameters. I might be blind though and just missed it. Any ideas as to what is causing this and how to resolve it? I apologize I usually do reports using a different package. The customer has been happy with the look and feel of the old ones.

Thanks!

Tom

8 Answers, 1 is accepted

answered on 15 Dec 2010, 08:08 PM

MultiValueError.png

Peter,
I appreciate the feedback. When I try to set the parameter to "IN" I get a exception and it will absolutely not accept the "IN" operator for a valid paraemter. I have inlcuded the error. Not sure what I need to do to bring the reports back to the previous status of allowing multiple values for the parameters. I did try the conditional formatting and got nowhere real fast. Any help you could provide would be greatly appreciated.

Tom

Accepted