XLReporter

Overview

Compatibility
Historical Interface
Advanced Calculations
Data Export
Statistical Analysis
Extending Excel
Testing Tools
Project Management
Viewer Auto Refresh
Enhanced Emailing

 

 

 

 

 

 
What's New in Version 8.0
 

Compatibility
Windows Vista and Excel 2007 compatible, complete with an updated look and feel consistent with the operating system theme.

With Excel 2007, XLReporter utilizes Microsoft’s Office Fluent user interface to provide an easy to use environment for you to design report templates.

more on the Office 2007 User Interface...


Improved Historical Interface

All of the historical interfaces provided by XLReporter have been improved. Every historical interface now provides a preview option where you can simulate historical data retrieval before you integrate it into your report.

A new customized historical interface to Rockwell's RSSql (Historian) has been provided to retrieve historical data.

Interfaces to Rockwell's RSView logs and Wonderware's InSQL have been improved both in functionality and in the speed of data retrieval.

The XLReporter simulated historical interface has been greatly improved allowing you a way to develop reports offline when no server is available.

Interfaces to classic historians have been pushed forward, overcoming server limitations. It is now possible to request such data as daily averages over a month or more than 5000 values without running into any server-side restrictions.

more on the History Group Builder...

Advanced Historical Calculations

back to top
Advanced client side calculations have been provided to reach beyond the standard server side calculations.

The following count the number of peaks and valleys of a process signal:
• slope.maxcount
The count of slope changes from positive to negative over the interval, e.g., the peak count.
• slope.mincount
The count of slope changes from negative to positive over the interval, e.g., the valley count.

The following count the number of ON/OFF states and the length of time in those states:
• state.incount
The number of occurrences where the value is within the state criteria over the interval.
• state.outcount
The number of occurrences where the value is not within the state criteria over the interval.
• state.induration
The amount of time where the value is within the state criteria over the interval.
• state.outduration
The amount of time where the value is within the state criteria over the interval.

The following produce differences and accumulations between the values:
• accumulation.first / accumulation.last
The accumulated total of the first or last samples of every interval.
• difference.first / difference.last
The calculated difference between the first or last sample of the current interval and the first or last sample of the previous interval.
• acc.difference.first / acc.difference.last
The accumulated total of differences of every interval.

more on the History Group Builder...
 
 

 

Data Export

back to top
Take information from your reports and export it to a number of different places including:
• Any relational database
• A text or CSV file
• Process tags in a real time server
• XLReporter functions

Once that data has been exported, it can be used either by other applications or as data in another report.

more on Data Export...

 

Statistical Analysis 

back to top
A suite of analysis routines have been provided as part of XLReporter’s management. These routines can be applied to your report data to produce calculations like covariance, correlation, moving average, frequency distribution and much more.

 

Extending Excel

back to top
If you don’t know how much data the report will contain, you cannot effectively set up any charting or summary calculations ahead of time. Because of this, worksheet management routines have been provided. With these routines you can apply report formatting, color coding “out of bound” values, filtering and sorting as well as re-calibrating chart series and other cell references to reflect the exact amount of data in the report.

more on Management...

 

Testing Tools 

back to top
Test your report before deploying it. XLReporter has provided tools for you to test your reporting solution during every step of development.

The System Check is provided to check your overall installation and to test real time data retrieval.

When configuring a history group or database group, the preview option is provided to test connectivity and data retrieval based on your settings.

After configuring a template in Excel, the Worksheet Execute option is provided to ensure the template is free of errors.

As part of designing a schedule, any command can be executed to ensure it is free of errors. When executing a command, you can specify a date and time on which to execute and that command will execute as if it were the time you specified. You can also execute the command over a date period and it will execute every time it should over the start and end dates you specify.

Taking this concept one step further, if you execute a command to update a report and that report contains historical data, the data retrieved will also adhere to the date and time you specify. Using this, you can backfill reports that may have been missed or generate reports from data collected before the reporting solution was ever implemented.

 

Project Management

back to top

Organize multiple custom reporting solutions into separate reporting projects. The Project Explorer is provided to easily transition between all the projects created. The Explorer contains all the tools to launch any reporting application and user document.

If you need to create a new project for different data sources that what you have installed for, you can now specify them as part of setting up the new project.

 

Viewer Auto Refresh

back to top
XLViewer now has an auto-refresh option. Using this option, the opened report is automatically reloaded to show the most recently saved file periodically.


Enhanced Emailing

back to top
XMailer has been enhanced to support both Mail Merge and Broadcast mailing to either fixed list of recipients or a variable list from any relational database. In a Mail Merge, the E-mails can be personalized using descriptive keywords.

Reports can be sent as attachments in either Excel or PDF format. In addition, reports in HTML format can be embedded in the body of the E-mail.


© 2007 SyTech, Inc. All Rights Reserved.