Home
Reporting
Create state of the art project reports without limits.
WinCC OA Excel Report
WinCC OA Excel Report, is a program extension of MS Excel for integrated data evaluation and protocol generation with WinCC OA archive data. Reports can be created with the WinCC OA Excel Report. Templates are used for the reports. If a report is to be generated over a defined period of time, the system accesses the template and automatically fills it with data from the process database. Reports can also be created, printed and saved on a scheduled basis without requiring user access.
Requirements

Version Information
Release Notes, Update information, Certifications and Frequently Asked Questions.
Concepts
Your first step into modern and powerful process visualization.
Deployment
Topics, you need to know, before using WinCC OA.
Security
Go beyond the norm in cybersecurity.
Engineering
Powerful tools for easy or complex engineering tasks.
Data Management
Classify, structure and archive your data.
Business Logic / Control
Endless possibilities in data processing for your projects.
Data Visualization
User interfaces, Trends and Reports for every purpose and device.
Southbound Interfaces
The process connection to the actual machines/sensors.
Northbound Interfaces
Your portal to the cloud or supervising systems.
Web Connectivity / Network Interfaces
Data exchange, APIs and web technologies
User Management
All about authorization, authentication and login-customization.
Availability
How to get your system uptime to the maximum.
Reporting
Create state of the art project reports without limits.
- XML Reporting
  The Reporting feature allows you to create reports in XML format. Therefore, add the WinCC OA Reporting Manager to your project. Historical data can be queried via the Reporting manager by using the SOAP (Simple Object Access Protocol) interface. SOAP is a network protocol which allows sending data in XML format between systems.
- WinCC OA Excel Report
  WinCC OA Excel Report, is a program extension of MS Excel for integrated data evaluation and protocol generation with WinCC OA archive data. Reports can be created with the WinCC OA Excel Report. Templates are used for the reports. If a report is to be generated over a defined period of time, the system accesses the template and automatically fills it with data from the process database. Reports can also be created, printed and saved on a scheduled basis without requiring user access.
- REST Reporting API
  The REST Reporting API is integrated into the Standard web server and can be activated via the config entry enabled in the [restReporting] section.
- Insights Hub Connector
  The Insights Hub connector allows you to upload data from WinCC OA to Siemens Industrial Cloud Insights Hub and to process data. WinCC OA supports the integration of SCADA data from WinCC OA to Insights Hub.
Addons
Useful tools and enhancements for special demands.
Reference Tables
Detailed and extensive content for special project adaptation.
Videos & Tutorials
Explore the capabilities of WinCC OA with our carefully selected collection of video tutorials and guides.
WinCC OA Documentation
Basic information about terms and functions within the documentation.
Disclaimer
A brief clarification of liability exclusions or legal notices.

Requirements

Install Excel Report. The Excel Report is part of the base installation.
Windows Operating System
Correctly installed version of MS Excel - see chapter Software requirements.
The Microsoft Sub installation MDAC 2.7 (that is a superset of ADO) is executed instead if it is required for the use of a feature and it is not installed yet.
Use of the "History DB" (WCCOAvalarch), "RDB Archiving" (WCCOArdb) or NextGen Archiver (NGA).
You will need your own license to run Excel Report.
The following files are included with WinCC OA and are located in C:\Windows\System32\ or in the installation directory of WinCC OA:
- mscomctl.ocx
- mscomct2.ocx
- SubTimer.dll
  Note: If an error occurs during the installation of WinCC OA, a manual registration of the library (SubTimer.dll) must be performed. Open the command prompt as administrator and execute c:\Windows\SysWOW64\regsvr32.exe <NAME>.dll.

CAUTION: Note that if you use statistical functions and have specified the "Always start calculation at" time on the synchronization tab of the data point function, the start time for the report has to be the same as the "Always start calculation at" time of the DP function (otherwise, the report won't get the required data).

CAUTION: The correct installation order of Office and WinCC OA is very important, otherwise the functionality of Excel Report is not granted and some errors may occur. Install Office first and WinCC OA afterwards. Furthermore, please keep in mind that you have to reinstall WinCC OA if you update your Office version.

Note: To be able to use the Excel report in the example projects (Demo Application and Getting Started), you have to copy all files from the <wincc_oa_path>\data\xls_report to <proj_path>\data\xls_report.