I'm trying to create a new dataset in RS that will execute a MySQL sproc. After selecting "stored procedure" as the query type on the dataset properties window, I can select the procedure from the drop down. Anyone familar with this process knows that the selected procedure appears in the box as schema_name.proc_name however when I click ok a syntax error is thrown. Does anyone know what should be changed to avoid the syntax error?
The data source is correctly set up. In fact, I have a second dataset of query type text that successfully selects from a MySQL table and returns report data. The issue is with calling MySQL stored procedures from SSRS.