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?

HI Suz ! It might be due to SSRS doesn't parse your MySQL Statement. Please make sure your syntax is correct. Thanks, Hasham Niaz

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