0
votes
0answers
387 views

Calling a MySQL stored procedure with parameters in SSRS reporting through ODBC

In SSRS, when I pass hard-coded values to my stored procedure, it works fine. But it doesn't work when I try to pass the parameters. Can you please tell me the right syntax for calling MySQL stored ...
1
vote
2answers
1k views

Connect a linked server to MS Reporting Service?

I've got a MYSQL server setup as a linked server in MS SQL server 2008. Can someone tell me if it is possible to generate reports from this server? How do I connect it to Reporting Services?