Multiple data sets, different paths
Hello
I have a D5 app using RB ENT. The app is multi-company i.e. there are
multiple databases stored in different subfolders of the main application
data folder.
Each sub folder data structure is identical.
i.e.
C:\DATA - main app data folder
C:\DATA\Company1 - company 1 data
C:\DATA\Company2 - company 2 data
etc
I need to be able to design (at run time) a report and then be able to use
it across all companies - but I can't see a way to change the alias or data
path before running the report.
Is this possible?
Nick Gebbett
I have a D5 app using RB ENT. The app is multi-company i.e. there are
multiple databases stored in different subfolders of the main application
data folder.
Each sub folder data structure is identical.
i.e.
C:\DATA - main app data folder
C:\DATA\Company1 - company 1 data
C:\DATA\Company2 - company 2 data
etc
I need to be able to design (at run time) a report and then be able to use
it across all companies - but I can't see a way to change the alias or data
path before running the report.
Is this possible?
Nick Gebbett
This discussion has been closed.
Comments
The ReportBuilder Query tools do not support accessing data across multiple
database for a single report.
You need to create one or more Custom DataViews (see
RBuilder\Demos\EndUser\Custom DataViews) or use external datasets that
reside on a Form/DataModule.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com