*Configure Reports

Reports can be generated from any open database that has an OLE-DB provider.  You can use data that is logged with data logging, or alarm that have been logged with alarm logging.

Follow the steps below for a simple report example or view the following video.

https://www.opcsystems.com/opc_report_net_video.htm

For a complete list of all Report properties refer to the OPC Systems Configuration-Reports section in this help file.

Step

Task

1

First complete the Configure Data Logging example and put the OPC Systems Service in Runtime mode to log data.

2

Start the Report Designer application from the program group OPC Systems.NET.

3

Select File-New to clear the current Report Designer workspace.

4

Select File-Add New Report

5

Use the Build Connection String button to specify a data source.

6

Specify the correct Provider for your database.

7

Select the proper Server with Windows NT Integrated security if using SQL Server Desktop.

Select OPCSystemsDemo database.

8

Use the Test Connection button to verify proper database connection and select OK

9

Select SimulationTable from Tables and then Next

Note

You can also define an SQL Statement to define your own query or use a View from the database engine.

 

10

Move all Available fields into the Detail window.

11

Select the default of Tabular report layout, then Next.

12

Select the desired template style.  The report colors, fonts, and images can be altered from these defaults.

13

Select to Modify the reportsí design.

14

Select the DateAndTime field in the Detail section of the report and using the Properties window in the lower left set the  to set the Format Property to Time.

15

Stretch the size of the Sine_Value field in the Detail window to a larger width.

16

Select File-Save and save the file with the name ReportDemo in the directory of your choice.

This creates the XML file that is selected in the Configure Reports step.

17

Start Configure OPC Systems application.

18

Select Configure-Reports.

19

Select the Local OPC Systems Service.

20

Enter the Report Name of Simulation in the field in the upper right.

21

Browse for the XML you just created with the Report Designer.

22

Select the Report you created in the Report Designer using the Report list box.

 

23

Select the desired Output Type.  Choose a type that you have a application to view the file with.

24

Specify the Output Path for the file.  You do not need to put an extension on the file.

Specify the

25

Set the Execution Type to Continuous.

26

Set the Execution Rate to 60 Seconds.

27

Specify the Filter as None for now.  With large amounts of data this would be important to filter the query to only the data of interest for the Report.

28

Select the Add button to add the Report.

29

Select the Save button on the toolbar at the top.

30

Save the file DemoReport.Reports in the directory C:\OPCSystemsDemo.

Use Configure-Options to automatically load this configuration file when the OPC Systems Service starts.

When you start the Service in Runtime mode reports will automatically be generated every minute.

You can also define an output type of PDF and set the option to E-Mail the report when it is generated.

More:

Reports CSV Export and Import

Report Query String

Manual Report Generation

Reports Programmatic Interface