WizReport XL Server Guide - support.wizcon.com

1 Axeda Supervisor Axeda Supervisor Axeda Supervisor Axeda Supervisor The complete InternetThe complete InternetThe complete InternetThe complete Internet----based solution for control and informationbased solution for control and informationbased solution for control and informationbased solution for control and information WizReport XLWizReport XLWizReport XLWizReport XL Server GuideServer GuideServer GuideServer Guide August 2005 August 2005 August 2005 August 2005 Server Guide WizReport XL Server Guide Version The new bridge between your data and your worksheet.

2 Information in this document is subject to change without notice. Axeda or SyTech assume no responsibility for any errors or omissions that may be in this document. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the prior written permission of Axeda or SyTech. WizReportTM XL is a trademark of Axeda Systems Inc. WizReportTM XL is based on XLReporterTM from SyTech, Inc. Copyright 2000-2005 SyTech, Inc. All rights reserved. XLReporter and XLR are trademarks of SyTech, Inc. Microsoft is a registered trademark of Microsoft, Inc. Windows, Windows 95/98, Windows XP, Windows 2000, Windows NT, Windows 2003 Server and Excel are trademarks of Microsoft.

3 Axeda Supervisor and Wizcon are trademarks of Axeda Systems, Inc. FIX and iFIX are registered trademarks of GE Fanuc Intellution. iHistorian is a trademark of GE Fanuc Intellution. DeltaV is a trademark of Emerson Process Systems. Intouch and InSQL are a trademark of Wonderware Corp. Citect is a trademark of Ci Technologies Ltd. MicroScan Scada is a trademark of Intech Instruments Ltd RSLinx, RSView and RSLogix are trademarks of Rockwell Software Inc. Version Contents Axeda Supervisor / Wizcon 5 Real-time Data ..5 OPC Tag Names ..5 OPC Tag Remote Connections ..6 Connecting to the Wizcon Historian ..7 Configuring a History Group Columns Time Cell-based and Variable Configuration.

4 14 Previewing the History Group ..14 Completing the History Group ..15 ODBC Historical Data ..15 Setup in Retrieve Start of the Scheduler ..17 GE Fanuc Intellution FIX and iFIX 19 FIX/iFIX Real Time Data ..19 FIX/iFIX History iFIX Alarm and Event Log Setting up FIX/iFIX for Alarm and Event Access: Alarm Log and Event Log ..19 Configuring for FIX/iFIX ..20 Real Time Access: Building a Real Time History Access: A Primer on Database Connections ..21 History Access: Overview of History Group Connections ..21 History Access: Starting the History Group ..21 History Access: Configure the Columns Tab ..22 History Access: Configure the Time Tab.

5 23 History Access: Variable Configuration ..24 History Access: Completing the History Group ..24 Starting the Scheduler ..25 Command Line Execution in FIX ..25 Display Push Button in Command Line Execution in iFIX ..26 Display Push Button in Program Block ..26 Data Access to a Remote iFIX ..26 GE Fanuc Proficy Historian 29 Retrieving Data from Proficy Historian ..29 Setting up Proficy Historian for Reporting ..30 Accessing Proficy Historian from a Remote Node ..30 Configuring for Proficy Historian ..30 History Access: A Primer on Database Connections ..30 History Access: Overview of History Group Connections ..32 History Access: Configure the History Group Setup Server Guide WizReport XL Axeda WizReport XL ii/140 History Access: Configure the Columns Tab.

6 34 History Access: Configure the Time Tab .. 37 History Access: Configure the Filter Tab .. 38 History Access: Configure the Order Tab .. 42 History Access: Cell-based and Variable Configuration .. 42 History Access: Querying a List of 43 Rockwell Software RSLinx 47 Overview .. 47 RSLinx & OPC .. 47 RSLinx 47 RSLinx configuration for OPC .. 48 OPC Tag/Symbol Browsing .. 49 Creating the Symbol Definition Database .. 49 OPC Group Selecting a Tag .. 50 Tag Name Syntax .. 51 Rockwell Software RSView 53 Overview .. 53 RSView Real Time Data .. 53 RSView Logged 53 RSView Alarm and Activity Log 54 Setting up RSView for Reporting.

7 54 Real Time Access: Enabling the OPC Server in RSView32 .. 54 Real Time Write Access: Allowing XLRSetValue access to 54 History Access: Overview .. 55 History Access: Configuring a Data Log Model .. 55 History Access: Starting a Data Log Model for Collection .. 56 Alarm and Activity Access: Alarm Log and Activities 56 Configuring for Real Time Access: Building a Real Time Connection .. 57 History Access: A Primer on Database 58 History Access: Overview of History Group 58 History Access: Configure the History Group Setup Tab .. 60 History Access: Configure the Columns Tab .. 63 History Access: Configure the Time Tab.

8 66 History Access: Configure the Filter Tab .. 67 Configuring the History Group Order Tab .. 70 History Access: Cell-based and Variable Configuration .. 70 History Access: Querying a List of 71 History Access: Troubleshooting .. 74 Emerson Process DeltaV 75 Overview .. 75 OPC Interface for Real-Time Data (Application Station).. 75 Tag 75 Remote OPC and OPC HDA Connections .. 76 Fix Interface for Real-Time Data (Pro-Plus) .. 77 Tag 77 Server Guide WizReport XL Axeda WizReport XL iii/140 Connecting to DeltaV s OSI-PI Configuration Settings.

9 77 Configuring a History Group Columns Time History Access: Cell-based and Variable Configuration ..81 Connecting to DeltaV s OPC-HDA Historian ..81 Configuring a History Group Setup Tab ..82 Columns Time History Access: Cell-based and Variable Configuration ..88 Previewing the History Group ..88 Completing the History Group ..89 Connecting to DeltaV s Batch and Journal Database ..89 Start of the Scheduler ..89 Command Line Execution in DeltaV versions with iFIX ..90 Display Push Button ..90 Command Line Execution in DeltaV versions with FIX ..90 Display Push Button ..90 Wonderware InTouch 91 InTouch Real Time InTouch History Data.

10 91 Setting up InTouch for Reporting ..91 Configuration Settings ..91 External Programs for Historical Data Access ..92 Configuring Reporting for InTouch ..93 Real Time Access: Building a Real Time History Access: Overview of History Group Connections ..93 History Access: Configure the Columns Tab ..95 History Access: Configure the Time Tab ..96 History Access: Variable Configuration ..97 Command Line Execution ..97 Display Push Button ..97 Troubleshooting ..97 Wonderware Industrial SQL Server 99 Retrieving Data from Setting up InSQL ..100 Connecting to Summary Tables from InSQL ..100 Configuring Reporting for History Access: A Primer on Database Connections.