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

MultiValue Error

3 Answers 56 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Philip
Top achievements
Rank 1
Philip asked on 15 Feb 2010, 05:03 PM
I have a report generated through the report wizard. I have set up three parameters, Service, Mod. Number and Status.

I have the filters working properly, but I would like for the user to have the selection to see Open, Closed or All in the status field.

The user can now select Open or Closed. If I set the MuliValue to true on the third parameter (status) and allow the user to "Select All", I get the following error on all selections:

An error has occured while processing Report: Cannot perform '=' operation on System.String and System.Collections.ArrayList.

Any help on this would be greatly appreciated.

3 Answers, 1 is accepted

Sort by
0
Massimiliano Bassili
Top achievements
Rank 1
answered on 15 Feb 2010, 05:26 PM
Take a look at this forum thread: http://www.telerik.com/community/forums/reporting/telerik-reporting/multivalue-parameter-with-stored-procedure.aspx


0
Philip
Top achievements
Rank 1
answered on 15 Feb 2010, 05:32 PM
Thanks for that. Up until this point, I have strictly used the chart wizard and the graphical interface.

Do I need to get into coding somehow to correct this? I havent used any coding so far. Can this be done through the graphical interface?
0
Massimiliano Bassili
Top achievements
Rank 1
answered on 16 Feb 2010, 03:36 PM
As you can see from the post, the user function you've created can be used in a textbox value as expression.
On one side you have a report parameter that is of type string and accepts multiple values, on the other hand you have a filter that has to be modified in order to work with multiple values. I believe the last reply in the post shows you the required changes:

single value:
WHERE CustomerID = @CustomerID

for multivalue parameter should be:

WHERE CustomerID IN (@CustomerID)
Tags
General Discussions
Asked by
Philip
Top achievements
Rank 1
Answers by
Massimiliano Bassili
Top achievements
Rank 1
Philip
Top achievements
Rank 1
Share this question
or