Single Report, Multiple Databases

rbuser

I have used Report Builder Enterprise in the past for single database
end user reporting solutions with good success. My current client
situation has the following environment:

- custom Delphi app using Firebird (Delphi 7, RemObjects SDk, dbExpress)
- MAS200 accounting package using MS SQL Server

I have a need to create a single report using data from both databases.
Can this be done with the Report Builder architecture?

Thanks,

Steve Beebe

nicocizik

Hi Steve,

Yes this is possible. If you are using DADE, you will need to create two
separate DataViews with separate connection settings to access both
databases. Remember that ReportBuilder is only designed to allow one
dataset per Report/Subreport. You will not be able to display data from
both databases inside the same detail band unless you use subreports.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks, Nick. That's what I needed to know.

Steve