locked
error creating dataset with MySQL stored procedures from SSRS 2008 RRS feed

  • Question

  • 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?  

    Monday, July 23, 2012 7:34 PM

Answers

  • 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
    • Proposed as answer by Edward Zhu Monday, July 30, 2012 8:41 AM
    • Marked as answer by Mike Yin Tuesday, July 31, 2012 5:49 PM
    Monday, July 23, 2012 9:56 PM

All replies

  • HI Suz !

    It might be due to SSRS doesn't parse your MySQL Statement. Please make sure your syntax is correct.

    Thanks, Hasham Niaz

    Monday, July 23, 2012 8:08 PM
    Answerer
  • 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
    • Proposed as answer by Edward Zhu Monday, July 30, 2012 8:41 AM
    • Marked as answer by Mike Yin Tuesday, July 31, 2012 5:49 PM
    Monday, July 23, 2012 9:56 PM