Create a Crystal Report

Before you begin

Ensure that Crystal Reports is integrated with the Historian server whose data you want to analyze. For instructions, refer to Connect to the Historian Server.

About this task

This topic describes how to import Historian table data into Crystal Reports and create a report.

Procedure

  1. In Crystal Reports, select File > New.
    The Crystal Reports Gallery window appears.
  2. Select Using the Report Expert > Standard Report Expert, and then select OK.
    The Standard Report Expert appears.
  3. Select Database.
    The Data Explorer appears.
  4. Open the More Data Sources folder, and then open the OLE DB folder.
  5. Select Make New Connection > Add.
    The Data Link Properties window appears.
  6. Select Historian OLE DB Provider > Next.
    The Connection section appears.
  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. Select OK.
    The Historian OLE DB provider tables appear in the Data Explorer.
  9. Select the table that you want to query, select Add, and then select Close to exit the Data Explorer window.
  10. In the Fields section of the Standard Report Explorer window, 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 create a report on numeric data in the Value or Quality column 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 Format Decimal Point Precision for instructions.
  11. Repeat the previous step for each field that you want to add, and then select Finish.
    The Crystal Report is generated.