Crystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources. You can use the Fernhill SCADA ODBC driver to provide data directly to Crystal Reports.
1. Start SAP Crystal Reports.
2. On the Start Page click Standard Report Wizard. The Standard Report Creation Wizard opens:
3. Expand Create New Connection, then expand ODBC (RDO). The ODBC (RDO) dialog opens:
4. Select My Fernhill SCADA. Click Next>. The Connection Information page opens:
Note: This step assumes an ODBC User DSN called My Fernhill SCADA has been set up.
For more information see Setting up an ODBC User DSN.
5. Leave the User ID and Password fields blank. Click Finish. The ODBC (RDO) closes, returning you to the Standard Report Creation Wizard:
6. Expand TagDB to show the Schema names in Fernhill SCADA
Note: The list of schema names shown may be different to the list shown on your computer.
7. Expand CommonBase then double-click TagDataPointAnalog. The Fernhill SCADA table TagDataPointAnalog appears in the Selected Tables list:
8. Click Next>. Add these fields to the Fields to Display list: FullName, DisplayValue, and Timestamp.
9. Click Next> three times to complete the Fields page, and skip over the Grouping and Record Selection pages. The final page of the Standard Report Creation Wizard allows you to select a Template.
10. Click Finish. The report is displayed in the Crystal Reports application:
Note:
To learn about configuring ODBC data Source Names.
Fernhill SCADA ODBC DriverTo learn how the Fernhill SCADA ODBC Driver can provide data to other applications.
For the meaning of terms used in Fernhill SCADA.