XLReporter

Overview

Design
Report
Manage
Publish

Used in all Industries

Special Features
System Requirements
Licensing Policy

Design for XLReporter’s Aggregate Database
Aggregate calculations produced from real-time data.
Calculations scheduled to update periodically or on-demand
Variety of aggregate calculations:
     . Digital Profiler for monitoring ON/OFF counts and durations
     . Difference for integrating totalizers
     . Statistics for calculating process parameters

more on Aggregates...
  

Step 2 - Report	back to top
Report in the Background - Automatically Generate reports without Excel visible or active Manage the entire reporting process by the scheduler      Periodically, e.g., daily, weekly, monthly      Based on alarms and events, e.g., a process condition or exception      Based on real-time Server values      Based on expressions or calculations Full flexibility provided by reporting commands Create workbook and worksheets from templates Update report workbook and worksheets Apply analysis to report workbooks and worksheets Publish completed reports as web pages Print complete reports to any networked printer Convert reports to HTML or secure PDF files Execute any external application Easily integrate custom macros Send a ‘report complete’ message to the data Server Report from scripts/VBA and HMI Displays Access all reporting commands from a programming interface Report On-Demand  Change template parameters without editing the template directly  Initiate from HMI displays, command line or from within Excel Select available report templates from lists Display reports in an integrated view window  more on Interactive Reporting...
Step 3 - Manage	back to top
Turn Raw Process Data into Valuable Information Define management routines in the Management configurator Automatically execute from either the scheduler or on-demand  Automatically apply to report data after “collecting” from the data source Full support of Management Operations: Data filtering, eliminates rows of data that do not meet a criteria Data sorting Formatting options, including font size, colors and borders Excel chart fitting to the exact amount of data in the report much more Full support of Management Calculations: Covariance Correlation Frequency Distribution Moving Average Analysis of variance (Anova) Calculation of new values and cell formatting based on a lookup table Integration of custom function(s) for automated report execution Much more more on Report Management... Charting and Excel’s Standard Calculations Use all the standard features of Excel: Charting functions for displaying data in graphical form Over 200 functions to enhance a report
Step 3 - Publish	back to top
Publish Reports as Excel Workbooks File storage to local/networked drives or file servers Protect reports by using a Workbook pass code View reports in Excel or Excel Viewer (freely available)   Publish to Printers Print reports to any local or remote (network) printer   Publish as Secure PDF Files Adobe Acrobat not required for PDF generation Create PDF files automatically or on-demand Protect reports with selectable encryption levels   Publish as Web Pages Available as a standard feature Save the entire workbook or a single worksheet to HTML Append worksheets to an existing HTML file Support for Java or VB scripting inside the report template  View reports with any standard web browser such as Internet Explorer   PDF Viewer – The Secure Viewer View published PDF reports in a secure viewer Select reports from pre-configured lists, no need to browse the file system Launch from a HMI display by a pushbutton or script XLViewer – The Secure Viewer Available in XLReporter Suite/ Professional or available as an option View complete reports in a secure environment  Specify layout and file accessibility with a configurator Select reports from pre-configured lists, no need to browse the file system Protect reports from modification Launch XLViewer from a HMI display by a pushbutton or script   XWeb Director – Web Enable Reports Available in XLReporter Suite/Professional or available as an option Specify layout and file accessibility with a configurator Automatically update report index pages Navigate instantly to any web enabled report view a framed example view a non-framed example XMailer – The Automated Postmaster Available in XLReporter Professional, or available as an option Specify recipients, messages and report file attachments in a configurator Send the report automatically or on demand XFiler – The Complete File Management System Available in XLReporter Professional or available as an option Full management of files and resources of a hard drive Specify management rules in a configurator Extensive list of commands such as ‘Move’ and ‘Copy' Perform maintenance in the background, periodically or triggered on event.
Special Features	back to top
Status Logs Historically logging of every reporting transaction Invaluable tool for tracking system failures The Iterator The results from one report are used as input to another Create drill down and batch reports Easily join information from disparate databases
Used in all Industries	back to top
Water and Wastewater – EPA and Regulatory Agency reports Automotive – Production counts, utilization, SPC and quality reports Material Handling - Material flow rates, machine efficiency and usage reports Building Controls and HVAC – Energy usage, efficiency and maintenance reports Security – Personnel and time reports Power - EPA and maintenance reports Government – Government regulatory reports Chemical/Oil/Gas – Production reports and custody transfers OEMS & Machine Builders – Downtime, SPC and Six Sigma reports Biotech, Food and Pharmaceuticals – FDA 21 CFR part 11 and EC 178 reports.
System Requirements	back to top
Microsoft Excel 2000, 2003, 2007 and above Microsoft Windows NT, 2000, XP, Vista and above
Licensing	back to top
Evaluation License In evaluation mode, all the functionality provided with the full license of XLReporter is available. However, the software is only registered for a period of 120 minutes, with a limit of 15 tags. When the registration expires, the evaluation period may be restarted. Any development performed in evaluation mode can be used later with the full license. Full License A full license allows unlimited report generation from a licensed computer. Since the generated reports are in an industry standard format, they can be viewed from any networked PC without additional licenses.

© 2007 SyTech, Inc. All Rights Reserved.