Multiple ADO Recordsets

Posted by: blackriver on 4 August 2017, 3:18 pm EST

  • Posted 4 August 2017, 3:18 pm EST

    Hello all,

    I just recently started out working with AR 2.0 and I'm trying to find a way to use TWO recordsets to populate my report.
    I would like to use RecordSet1 to populate the details section,and RecordSet2 to populate the Header Section.
    How can I do this?I noticed that you can only use one ADO Data Control. Is there a way to add another? I don't want you to write the code for me,just help me out with basic logic.
    Thank you!
  • Replied 4 August 2017, 3:18 pm EST

    Hello,

    Thank you for your query. I would like to inform that you cannot connect ActiveReports to multiple recordset. However, you could always merge the two recordsets available to you and then pass the same into the report. You may take a look at these links regarding merging recordsets.

    Regards,
    Prantik
Need extra support?

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

Learn More

Forum Channels