Connection to multiple data-bases

rbuser

It is possible for my report to get his data from more than one
data-base, and if yes, how can this be done?


Regards,
Paul

nicocizik

Hi Paul,

Yes this can be done. Depending on which type of databases you are using,
you can connect datapipelines to any TDataSet descendent containing data
from almost any database. If you would like to traverse the data of each of
these datasets, you will need to use a subreport to do so. For instance, if
you would like to connect to a SQL Server database and an Access Database
using ADO, you would place two ADOConnection components on your form,
connect the data to two different TppDataPipelines, and connect one to the
main report and one to a subreport inside the main report. Hope this helps.

--