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.
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
0
Massimiliano Bassili
Top achievements
Rank 1
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
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?
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
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)
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)