I have a parameters (drop down list) containing all text values that I built by manually providing the values in Add Values (as opposed to from query). It contains about 10 values (Division).
It works. This drop down works fine by listing all available values and allows you to select one and returns correct results. But, I also need a default Select All option, so that users can select more than one value at a time or all values, and that's where the problem begins.
To activate the 'Select All' option I went to the parameter's General tab, checked 'Allow multiple values'
After I do that, I can still bring up the Preview page, and then see the drop down list has the (Select All) check box. I can also see the checkbox next to each one of the Division values. However, when I click Select All or any one of the values independently or together I get 'Loading....' followed by error
"An error has occurred during report processing. The processing of FilterExpression for the dataset 'PPCQuery' cannot be performed. Cannot compare data of types System.String and System.Object. Please check the data type returned by the FilterExpression."
Can you tell me how to solve?