Hi, I facing a problem to filter the result with parameter value that contains '&' character on Enesys v3.0.
For example, I have one parameter drop down list called category. There are three items on the category, that are "Male", "Female", "Male & Female" (Ignore double quote).
First, when I select "Male" from the parameter drop down list and do the filtering with CAML query. It works fine. But when I choose "Male & Female" from the drop down list to do filtering with CAML query. It give me the following error message.
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'DSGumusut'. (rsErrorExecutingCommand)
An error occurred while parsing EntityName. Line 1, position 54.
The following is my sample query
<list title="humanSex" relativeSiteUrl="/" tableName="tblHumanSex">
<fields>*</fields>
<query>
<In>
<FieldRef Name='Title' />
<Value Type='Lookup'>@category!</Value>
</In>
</query>
</list>
Help me please!