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

  1. Select New from the File menu in Crystal Reports.
    The Crystal Reports Gallery dialog box appears.
  2. Select the Using the Report Expert option, and then select the Standard Report Expert in the list of experts, and then click OK.
    The Standard Report Expert appears, with the Data tab selected.
  3. Click the Database button.
    The Data Explorer appears.
  4. Open the More Data Sources folder, and then open the OLE DB folder.
  5. Select Make New Connection and click Add.
    The Data Link Properties dialog box appears.
  6. Select the Historian OLE DB Provider, and then click Next to display the information in the Connection tab.
  7. 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.
  8. Click OK.
    The Historian OLE DB Provider tables should now appear in the Data Explorer.
  9. Select the table that you want to query and click Add, and then click Close to exit the Data Explorer.
  10. Click on the Fields tab of the Standard Report Explorer, click a field that you want to report on, and then click 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.
  11. Repeat the previous step for each field that you want to add, and then click Finish to generate the report.