DataSet query with Parameters does not work in Report Builder

Question

The following picture shows the query and its result with no variables:

The next one shows the same query with a variable and a different result:

This how the parameter was set just before the query execution:

I have also tried setting the parameter without '' but it produces the same result.

Any clue about what's going on? Any help would be greatly appreciated.

NOTE: The DBMS is MySql

Answer 1

This weird issue is due to the fact that SSRS is connected to MySQL by ODBC connector; therefore, the query parameters should be defined as ? and their names are Parameter1, Parameter2, etc... in order of appearance

Source: http://www.tek-tips.com/viewthread.cfm?qid=1354185