SSRS and MySQL?

[darwin101]

hi all

has anyone succesfully goten RS to work with MySQL? I can get basics to work, but I keep failing when I try to use parameters. the stuff I have found on the web has not been helpful... any suggestions or help would be greatly appreciated.

thanks in advance.

 

[darwin101]

MySQL can not handle named parameters, when I use ' ? ' the query works fine. This is when using ODBC.

 

[FooCorwin]

In your query, leave the parameters as '?' marks:

...
AND c.DownloadDate >= ?
AND c.DownloadDate <= ?
AND r.source = ?

You need to leave the parameters 'named' as Parameter1, Parameter2, etc., in the report.

Deploy the report like that -- then, in the Report Manager, for that report, you can set the display text for each parameter (to make it simpler for the user).