The end-user reporting solution in ReportBuilder Professional is comprised of three primary components that can be configured at Delphi design-time. Each component contains properties pertaining to data access.
1. Report Designer
The Designer's DataSettings object is used to specify the connectivity parameters for the query wizard and query designer tools. In a typical end-user reporting solution, the end users will be creating and modifying reports that access data residing in a departmental or corporate database.
2. Report Explorer
The Report Explorer's Folder and
Item objects are used to specify connectivity information for the folder and item database tables. These tables are used to store the folders, reports, and dataviews created by the end-user. Depending upon the specific requirements of the application, the folder and item database tables may reside in a local database on each user's workstation, or they may reside in the database server.
3. Data Dictionary
The DataDictionary's Table and
Field objects are used to specify connectivity information for the table and field database tables that are used to provide user-friendly table and field alias information to end users. The table and field database tables may reside in a local database on each user's workstation, or they may reside in the database server.
Local End-User Tables
In this scenario, each user has a local copy of the end-user tables that are used as a personal database for storing their reports. For example, suppose the corporate database resides on an Oracle database server and you decide to deploy the end-user tables locally using SQLAnywhere. To implement this strategy, you would configure the
TppDesigner.DataSettings to specify the connectivity parameters for the Oracle database server. The Report Explorer tables would reside in the local SQLAnyWhere database, and the Data Dictionary tables could reside in either place, depending upon your preference.
Shared End-User Tables
In this scenario, reports created by end users reside in a multi-user database that is shared. For example, if the corporate database resides on an Oracle database server, the end-user tables would also reside on the Oracle server.