Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

DataSet query with Parameters does not work in Report Builder

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

enter image description here

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

enter image description here

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

enter image description here

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

like image 289
aleafonso Avatar asked Dec 16 '22 23:12

aleafonso


1 Answers

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

like image 69
aleafonso Avatar answered Jan 17 '23 02:01

aleafonso