Multiple Queries in active reports

Posted by: newsb on 4 August 2017, 2:38 pm EST

  • Posted 4 August 2017, 2:38 pm EST

    Hi,
    I am not that familiar with the active reports.
    I need to get multiple results from the database using the RDO connection.
    One is the detailed rows
    Other is like count(*) from different table

    How can this be handled. Any pointers are helpful
    thanks
  • Replied 4 August 2017, 2:38 pm EST

    I recommend a partially unbound approach to accomplish this.  You can bind your report to your RDO connection, but then in your fetchdata, you can combine in your data from your second query to a Field that you add in the DataInitialize event.  See the following collection of helpfile articles on creating unbound reports:
    http://www.datadynamics.com/Help/AR2/AR2Std/HX_Chapter_6_Unbound_Reporting.html
Need extra support?

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

Learn More

Forum Channels