error creating dataset with MySQL stored procedures from SSRS 2008
I need to create a dataset in RS that will execute a MySQL stored procedure (with no parameters). The sproc does not return any values, it just refreshes a table in the MySQL db which a second dataset in RS will select from to acquire
report data. This approach is being used since MySQL does not support ref cursors like Oracle.
I'm getting a "could not create a list of fields" error after selecting the procedure in the dataset dialog window and clicking ok. Does anyone know why RS is throwing this error and how to remedy it? Every post I've read on this
issue is quite dated. Are there any widely used current solutions out there?
July 23rd, 2012 3:38pm
HI Suz !
It might be due to SSRS doesn't parse your MySQL Statement. Please make sure your syntax is correct.
Thanks, Hasham Niaz
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2012 4:12pm
Hi There
Thanks for your posting. Can you please make sure that
the same column name of two different tables does not return in your dataset, Because SSRS might not generate list of fields if you have two columns with the same name.
Please have a look in your stored procedure if you have two columns with the same name
Many thanks
Syed Qazafi Anjum
July 23rd, 2012 6:00pm