Home› General
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Can the RptDesigner support multiple database connections simultaneously?

rbuserrbuser
edited February 2007 in General
Fellow Report Builder Staff and/or Developers,

I am currently using Delphi 6 and Report Builder 9.01.

Can the RptDesigner support multiple database connections simultaneously
within the same report?

Some of our user would like to access multiple databases with different
connections simultaneously to display data in one report.

I can open and access multiple database connections in code, but I'm not
certain if this can be done on the Data tabsheet in the RptDesigner.

Thanks,

George Spicka
Software Developer - VISTA
Ticketmaster, Inc.
George.Spicka@Ticketmaster.com



--- posted by geoForum on http://delphi.newswhat.com

Comments

  • nardmoseleynardmoseley
    edited February 2007

    - Multiple connections are not supported by the Visual Data Access
    Environment.

    - As a work around, you could try defining some views in primary database
    that use tables from another database. I suggested that to another customer
    and they reported success using that approach.

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • rbuserrbuser
    edited February 2007
    Nard,

    "Thank You" for the information.

    That was one of the alternate approaches we were considering.

    George Spicka
    Software Developer - VISTA
    Ticketmaster, Inc.
    George.Spicka@Ticketmaster.com

    database
    customer



    --- posted by geoForum on http://delphi.newswhat.com
This discussion has been closed.