Software eases reporting plant personnel, system integrators

Sacramento, CA—WorkSmart Automation recently released its ReportBuilder Version 1.30 software tools designed for reporting historical data collected automatically by supervisory control and data acquisition (SCADA)/human-machine interface (HMI) systems and data collected manually.



Sacramento, CA— WorkSmart Automation recently released its ReportBuilder Version 1.30 software tools designed for reporting historical data collected automatically by supervisory control and data acquisition (SCADA)/human-machine interface (HMI) systems and data collected manually.


ReportBuilder is a set of data access tools and functions available within the Microsoft Excel workbook. These tools allow users to build complex industrial reports by placing data access functions into worksheets. New toolbars, menus and windows added to Excel allow users to choose data points by their respective tag name, description, and engineering units. Custom tag groups allow for storing multiple tags in a logical and easy to find format. Users can then analyze data and reports for different time frames by choosing the date and duration of the report they're interested in, or by clicking forward and backward buttons to report the previous or next reporting interval. Reports can be set for automatic output to printer, e-mail, HTML web, and Excel file formats for a completely automated reporting solution.


The company says system integrators will appreciate the software' s ability to build and reuse reports from project to project. Integrators often have to build the same or similar report for each project. Reusing previously configured reports increases profitability and lowers the total cost of ownership for end-users. ReportBuilder accomplishes this by connecting to all of the major SCADA/HMI solutions, such as Fix32, iFix, iHistorian, InTouch, InSQL, Lookout, FactoryLink, RSView, Cimplicity, and others. Optional ODBC drivers for accessing historical data by GE Fanuc's Fix32 and iFix, and Wonderware's InTouch log files make it possible to report on data as far back as collection began. Once reports are built, they can be reused on other projects with minimal modifications.


Likewise, plant personnel will appreciate ReportBuilder's ability to report on more than just SCADA/HMI logged data. Rarely is plant and process data ever collected completely by the SCADA/HMI system. Most municipalities and plants track other types of data by entering it into a database or spreadsheet. With ReportBuilder, plant personnel can report data from both SCADA/HMI and custom databases. Reports can be built that present data from one or more of the data sources seamlessly.


In addition, ReportBuilder's advanced import and export features include the ability to import project tag names, descriptions and engineering units to and from Microsoft Excel. The new Tag Import Wizard will import tags automatically from iHistorian, iFix, Fix32, and InSQL. With these features, users can be up and running in about 30 minutes.


Also, ReportBuilder's flexible functions provide options for filtering data based on time, values, and values of other tags in the system. Often, reports will include the minimum, maximum and average values for a given data point and interval. However, other factors must be considered when reporting including limiting these values to when other conditions exist, like high flow, backwash inactive, and others. ReportBuilder supports optional arguments for filtering data for these conditions.


'ReportBuilder brings a whole new outlook to system integrators and plant personnel when it comes to reporting. No longer are users required to present data without the proper tools to do so,' says Dan Jones, Work Smart's CEO. 'And with ReportBuilder's ease of use, we're seeing many system integrators offer reporting as a new service. We are also seeing plant personnel specifying ReportBuilder for their projects. Systems Integrators and end-users need tools that they can sit down with and are immediately productive.'


Control Engineering Daily News Desk
Jim Montague, news editor


No comments
The Engineers' Choice Awards highlight some of the best new control, instrumentation and automation products as chosen by...
The System Integrator Giants program lists the top 100 system integrators among companies listed in CFE Media's Global System Integrator Database.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
This eGuide illustrates solutions, applications and benefits of machine vision systems.
Learn how to increase device reliability in harsh environments and decrease unplanned system downtime.
This eGuide contains a series of articles and videos that considers theoretical and practical; immediate needs and a look into the future.
Controller programming; Safety networks; Enclosure design; Power quality; Safety integrity levels; Increasing process efficiency
Additive manufacturing benefits; HMI and sensor tips; System integrator advice; Innovations from the industry
Robotic safety, collaboration, standards; DCS migration tips; IT/OT convergence; 2017 Control Engineering Salary and Career Survey
Featured articles highlight technologies that enable the Industrial Internet of Things, IIoT-related products and strategies to get data more easily to the user.
This article collection contains several articles on how automation and controls are helping human-machine interface (HMI) hardware and software advance.
This digital report will explore several aspects of how IIoT will transform manufacturing in the coming years.

Find and connect with the most suitable service provider for your unique application. Start searching the Global System Integrator Database Now!

Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Mobility as the means to offshore innovation; Preventing another Deepwater Horizon; ROVs as subsea robots; SCADA and the radio spectrum
Future of oil and gas projects; Reservoir models; The importance of SCADA to oil and gas
Automation Engineer; Wood Group
System Integrator; Cross Integrated Systems Group
Jose S. Vasquez, Jr.
Fire & Life Safety Engineer; Technip USA Inc.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
click me