Hello,

Using a Report Designer of the SQL Server 2008 connecting to an ORACLE database:

- I want to use Parameters filters with multiple Values but i get the error :

"FilterExpression for the data set 'DATAset1' cannot be performed. Cannot compare data of types System.String and System.Object[]. Please Check the Data Type Returned by the FilterExpression"


without the multiple Values it works but don't resolve my problem.

The filter configuration is =Fields!DT_OPERACAO.Value = =Parameters!FLT_Ano_Lectivo.Value


how can i solve this situation ?

Hi,

This post appears to concern a product that relate to the SQL Server Reporting Services 2008. Please post the question in the forum for SQL Server Katmai Reporting Services. Here is the link: http://forums.microsoft.com/TechNet/ShowForum.aspx?ForumID=1624&SiteID=17

We recommend posting for the appropriate product in order to get the most qualified pool of support deliver team members.

Thank you for your understanding.

use the IN clause in your filter