|Page (1) of 1 - 04/18/12||email article||print page|
SyTech Releases XLReporter Version 10.0Excel Reports and Forms for Industry (April 18, 2012)
FRANKLIN, MA -- (Marketwire) -- 04/18/12 -- SyTech Inc., the leading provider of automated report generation and data analysis software, today announced XLReporter Version 10.0. This latest evolution provides two new components -- data entry management and reporting from text files. First, XLReporter's data entry component turns Microsoft Excel into a "design studio" for the creation of data entry forms, database design and linkage of the forms to the databases, without any programming. XLReporter then validates the data and stores it in a secure, central database, making it available for reports from local or remote client stations. Second, XLReporter's impressive list of interfaces has been expanded to include text files, enabling direct reporting from data loggers.
XLReporter's data entry component, Interactive Forms, is designed to set up the entire solution in the familiar environment of Excel, taking advantage of XLReporter's ability to deploy it across the network for gathering and storing information to a central database. Once deployed, users access the forms according to their credentials. Information entered in the forms is saved to the database using web services which ensures the integrity of the information and the security of the database. Interactive Forms is ideal for any industry that enters data manually, such as user recordings or laboratory results, combining it with automatically collected data for reporting without bringing in IT specialists.
Support for most databases, including Microsoft SQL Server and Access, ensures that Interactive Forms can be used in any industry, large or small.
"With Microsoft Excel as the 'design studio,' there was no need to learn anything new to create intuitive user entry forms complete with calculations, formatting and validation. This reduced our engineering time substantially," says Sarah Elger (P.E.) from Xylem. "In addition, maintenance of the database did not involve specialists because no programming was required."
The second new reporting component, the File Cabinet, addresses obstacles users face when creating reports from text files. Text files, like those created by data loggers, are usually generated periodically and consequently a report may span hundreds of files. Also, because the file content is text, analytics can only be produced with specialized tools or programming.
The File Cabinet technology enables the user to stitch together the data from disparate files into a single entity to produce reports that go beyond each text file. In addition, the File Cabinet automatically creates and maintains a list of tag names so tags can be simply selected by XLReporter's tag browsers. It features filtering and sorting together with analytic calculations such as the average for each hour of a day.
"Producing reports that incorporate manually entered data with production data is a challenge for industry," explains Peter Kaprielian, CTO of SyTech. "With this version of XLReporter, these challenges are met in one package."
Analytic calculations are also provided for historians. XLReporter is widely used with leading historians and SCADA systems by GE Intelligent Platforms, Wonderware, Rockwell Software, Emerson Process Management, and Siemens together with industry standards such as OPC, OPC-HDA, ODBC and OLE-DB.
An evaluation copy of the product can be downloaded from www.sytech.com.
About Xylem: Xylem spun off from ITT Corporation on October 31, 2011 and began a new chapter as a leading global water technology company with operations in more than 150 countries; a passionate, talented, and experienced workforce; well-known industry-leading brands and water solution products, 2011 revenues of $3.8 billion and a shared commitment to making a difference in communities around the world. Xylem comprises four business units -- Water Solutions, Flow Control, Analytics and Residential and Commercial Water. These four units are interconnected, anticipating and reflecting evolving needs and sharing their applications expertise to cover every stage of the water cycle.
About SyTech, Inc: SyTech has been providing report generation and analysis software since 1991. We are recognized as a leader in advancing the technology used to automate and distribute reports in Excel, PDF and Web formats. Our innovative approach delivers products that are quick to implement, reliable and cost effective. SyTech products are resold by automation software distributors and OEMs with implementations in 60 countries around the world. Our award-winning software XLReporter is endorsed by small municipal facilities as well as major international manufacturers and Fortune 500 companies.
Copyright @ Marketwire
Related Keywords: automation, SCADA, data logger, Excel, reporting tool, process control, manufacturing, OPC, Rockwell, GE, Marketwire, , Internet Technology, Biology, Business, Browsers,