To update a report in the ClearSCADA database, ViewX has to be running while the report is being edited in the Crystal Reports application. As each report must be saved using its original file name, we advise that you use the Crystal Reports’ Save, rather than the Save As option, to store your reports.
You display data in a report by adding ‘fields’ to that report. Each row of fields that you add to the Details section in the Crystal Reports application (see Understand the Crystal Reports Work Areas) defines the information that is to be displayed for the records that you include in your report.
Before you can display ClearSCADA data in a report, you need to check that you provide the necessary access to the ClearSCADA database (see Accessing the ClearSCADA Database).
In order to reference the relevant database tables and include the required ClearSCADA data in your reports, you need to be familiar with the ClearSCADA database structure and naming conventions—this information is covered in detail in the ClearSCADA Guide to the Database. For a summary of the ClearSCADA database structure, and information on using database tables and fields in reports, see Working with ClearSCADA Database Tables.
When configuring large or complex reports, or reports that query historic table(s), take care to adhere to the Important Guidelines on Configuring and Generating Reports. Inappropriate configuration of large or complex reports can affect system performance.
This section explains the different Field Types that you can use in your reports.
It also explains how to:
- Add a Field to a Report
- Specify the Order in which Data is Displayed on a Report
- Group the Data in a Report
- Limit the Data that is Included in a Report
- Allow Users to Specify which Data is Included in a Report.
Be aware that any changes to items in the ClearSCADA database can affect the content of your reports. For example, let’s assume you filter or group a report by FullName and later rename or move some of the database items that appear in the report. As you have changed the location and name of items, you will need to check that the filters for the report are still suitable as they may now cause the report to contain inappropriate records.
Further Information