using multiple resultsets

Posted by: pragatikaushik on 3 August 2017, 6:21 am EST

  • Posted 3 August 2017, 6:21 am EST

    Moved from the forum post:
    Originally posted by: atalati

    I have a question, could we have something like this in data-dynamics ? I
    am facing a same problem, where the stored procedure sends multiple [
    approx. 3 ] result sets and I'd like to have a way out so that Data
    Dynamics can handle it.

    And in the case of  affirmation, if could you please refer me the steps / walk-thru ... I'd greatly appreciate it.
    P.S. :
    stored procedure that returns 3 result sets, takes considerable long
    time to execute hence the application may not afford, with report having
    three different tables and calling the same stored procedure 3 times.
    Preferably we'd like to get all at once, and to know if data-dynamics
    can handle as three different result-sets.

    Thank so much in advance,

  • Replied 3 August 2017, 6:21 am EST


    I am working on your query. I will get back to you soon.

    Manpreet Kaur
  • Replied 3 August 2017, 6:21 am EST


    I tried using a stored procedure in Data Dynamics Reports returning multiple resultsets and I could observe that Data Dynamics Reports simply assigned the first resultset to the dataset for which the stored procedure was called. It could not assign all the three resultsets returned by the stored procedure to one dataset. So, it would not be possible to implement such a scenario in Data Dynamic Reports. I would try to find a workaround for the same and would share my observations with you on the same.

    Manpreet Kaur
  • Replied 3 August 2017, 6:21 am EST

    Can you please reply for this query :
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels