Creating a Crystal Report with Historian Data

About this task

The following instructions offer an example of how to import Historian table data into Crystal Reports. For detailed instructions on formatting and using Crystal Reports, refer to the Crystal Reports online Help.

To import Historian table data into Crystal Reports using the Standard Report Expert:

Procedure

Select New from the File menu in Crystal Reports.
The Crystal Reports Gallery window appears.
Select the Using the Report Expert option, and then select the Standard Report Expert in the list of experts, and then select OK.
The Standard Report Expert appears, with the Data tab selected.
Select the Database button.
The Data Explorer appears.
Open the More Data Sources folder, and then open the OLE DB folder.
Select Make New Connection and select Add.
The Data Link Properties window appears.
Select the Historian OLE DB Provider, and then select Next to display the information in the Connection section.
Leave these fields empty to use the default server and currently logged-in user. Otherwise, do the following:
1. Enter the name of the Historian server in the Data Source field.
2. Clear the Blank Password check box.
3. Enter a Windows username and password.
Select OK.
The Historian OLE DB provider tables should now appear in the Data Explorer.
Select the table that you want to query and select Add, and then select Close to exit the Data Explorer.
Select in the Fields section of the Standard Report Explorer, select a field that you want to report on, and then select Add to move the field into the Fields to display list.

Note: If you want to report on numeric data in the Value or Quality columns in the ihRawData table, you may want to convert all Variant data types to Float data types, so that Crystal displays them correctly in the report. Refer to Display Variant Data Type Columns as Floats in Crystal Reports for details.
Repeat the previous step for each field that you want to add, and then select Finish to generate the report.