In order to display Geo SCADA Expert data in a report, the Crystal Reports application needs to access the Geo SCADA Expert database. This access is made using an ODBC connection to the main server (see Connect to the Geo SCADA Expert Database). You need to specify this ODBC connection for each report on your system. (If your reports include subreports, you also need to specify the relevant ODBC connection for each of those subreports.)
You also need to specify the database tables that each report and subreport is to access (see Provide Access to the Relevant Database Tables).
If a report references more than one table, you need to Specify the Links Between Multiple Tables, or Use a Subreport to Include Unrelated Data in the Same Report.
In order to reference the relevant database tables and include the required Geo SCADA Expert data in your reports, you need to be familiar with the Geo SCADA Expert database structure and naming conventions—this information is covered in detail in the Geo SCADA Expert Guide to the Database. For a summary of the Geo SCADA Expert database structure, and information on using database tables in reports, see Working with Geo SCADA Expert Database Tables.
If required, you can include ‘custom’ database tables, such as Data Grids, in your reports (see Custom Tables and Fields). We do not recommend renaming or removing fields from a Data Grid Table that is used in a report. However, you can reflect renaming and removal changes by re-mapping the table data in the Crystal Reports application (see Map Field Changes to a Custom Table).