Report From Live Data

Report directly from process data (PLC) without a Historian or Relational Database

In a matter of minutes you will be creating professional reports from PLCs and controllers by Allen Bradley, GE Digital, Mitsubishi, Modicon, Omron, Siemens and more.

play_s.pngWatch video on reporting from on-premise data
play_s.pngWatch video on reporting from remote data
play_s.pngWatch video on reporting on batch and machine cycles

See also:

Report As You Run

A perfect choice for Users, Machine Builders and OEMs who need a low-cost, straightforward solution that does not require a historian or relational database. XLReporter's "Report As You Run" technology adds process data to the report periodically e.g., every 15 minutes or end of a shift, and by events e.g., start of backwash or the completion of a weigh cycle.

  • Create reports as workbooks, worksheets, pdf and web pages automatically on time or on process events
  • Use custom report names using combinations of fixed text, dates, times and values from PLC registers, for example the product or machine ID
  • Add data over time to the same report. Handle large blocks of data with ease (100,000 rows)
  • Add supplementary information such as comments and signatures, even to reports actively updating
  • Provide a "handshake" back to the PLC when the report is updated
Report directly from process data without a historian or database
solution-xlreporter-process-snapshot-report.png

Snapshot Report

Snapshot reports are the simplest type of Real-time report, containing raw values and summaries from the PLC at a moment in time. When used as a dashboard, the reports can be viewed as they are being updated.

  • Display values in free format, columns or rows
  • Use arrays to retrieve blocks of PLC data
  • View the data on a mobile device
solution-xlreporter-process-summary-report.png

Summary Report

Summary reports are produced over a period of time. In this solution, a library template is used to report values every hour of a day. When a report is completed, a new report is created automatically.

  • Add values in columns and rows periodically e.g., every minute, 15 minute, hour, day
  • Position values in the report by placement e.g., place the values using the hour of the day
  • Provide intermediate calculations that use the PLC values
solution-xlreporter-annual-flow-summary-report.png

Annual Production Report

The annual production report contains the production for an entire year, organized in monthly reports. In this solution, a library template is used to monitor the annual production of a water treatment facility.

  • Position values in the report by placement ensures values are placed on the correct row of the report
  • Provide summary calculations
  • Share information between reports
solution-xlreporter-monthly-operating-report.png

Monthly Operating Report (MOR)

The monthly operating report is an example of a regulatory report. In this solution, the Monthly Operating Report from the State of Oklahoma is shown as the Excel file "as is" from the State's website. No redrawing, no touchup.

  • Import State forms to produce regulatory and compliance reports
  • Automate the update of reports that are currently updated manually
  • Circulate reports automatically every day and keep personnel informed
solution-xlreporter-batch-summary-report.png

Batch Summary Report

The batch summary report is an example of a report that is updated during a cycle e.g., while a machine is running or during a pumping stage. In this solution the PLC is monitored for the start of a batch at which point a new report is produced and updated periodically until the batch ends.

  • Update the reports periodically during a cycle
  • Name the reports using fixed text, dates and values from the process such as a Product Code or Machine ID
  • Organize multiple reports in a single workbook (using the batch name as the worksheet name)
solution-xlreporter-weigh-cycle-report.png

Weigh Cycle Report

The weigh cycle report is an example of a report that is updated each time an event occurs. In this solution the PLC signals a weighment is complete that causes the report to update. Comments are added to the report at any time to explain out-of-tolerance, indicated by background color of a value.

  • Update the report by adding a new row or column of values on event
  • Highlight exception by color coding
  • Add operator comments to the ‘live’ report without affecting the report update
solution-xlreporter-shipping-summary-report.png

Shipping Summary Report

The shipping summary report is an example of a report that is updated each time an event occurs. In this solution, the PLC signals a weighment is complete that causes a shipping label to be produced.

  • Update the report by adding a new row or column of values on event
  • Use hyperlinks to other report pages
solution-xlreporter-shift-production-report.png

Shift Production Report

The shift production report is an example of a report that is updated periodically in multiple columns. In this solution a daily report shows side-by-side shift performance for easy comparison.

  • Update the report by adding a new row values at specific columns
  • Use summary calculation across columns and rows of values
  • Display key performance indicators to determine good, average or underperforming
solution-xlreporter-mobile-snapshot-report.png

Mobile Snapshot Report

The mobile snapshot report is an example web report that is viewed in a browser. In this solution, report is updated periodically, overwriting the existing.

  • Produce web pages with absolutely no scripting
  • Automate the update of the web reports and view them on mobile devices and tablets
  • Use the FTP client to publish to a remote web server

See a report at www.XLReporter.net on a mobile phone.