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
In Crystal Reports, select File > New.
The Crystal Reports Gallery window
appears.
Select Using the Report Expert > Standard Report Expert, and then select
OK.
The Standard Report Expert
appears.
Select Database.
The Data Explorer
appears.
Open the More Data Sources folder, and then open the OLE DB folder.
Select Make New Connection > Add.
The Data Link Properties window
appears.
Select Historian OLE DB Provider > Next.
The Connection section
appears.
Leave these fields empty to use the default server and currently logged-in user. Otherwise, do the following:
In the Data Source field, enter the Amazon Network Load Balancer (NLB) DNS.
Tip: To find the NLB DNS:
Access the EKS cluster on which you have deployed Proficy Historian for AWS.
Access the EC2 instance.
In the navigation pane, under Load Balancing, select Load Balancers.
Select the load balancer for which you want to find the DNS.
In the Description section, copy the DNS name.
Clear the Blank Password check box.
Enter a Windows username and password.
Select OK.
The Historian OLE DB provider tables appear in the Data
Explorer.
Select the table that you want to query, select
Add, and then select
Close to exit the
Data Explorer window.
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.
Repeat the previous step for each field that you want to add,
and then select Finish.
