www.dreamreport.com

Richard KayeOcean Data Systems

Dream Report is…

…professional Designer-Friendly™ Reporting Software for

Industrial & Process Automation

Scalable All-In-One Solution

• Simple installation

• Access to Aggregated, Live and Raw Historical Data

• Produces Web, PDF, Excel, Database output

• Automatically Send to Printer, Email and Browser

Easy-to-use

• Quick learning curve

• No programming or scripting

• No software development skills are required to design reports

Open & Direct Connectivity

• Real-time connectivity to SCADAs, HMIs, PLCs, …

• Direct connectivity to process Historians

• Connectivity to business data sources & databases (SQL Server, MySQL,

Oracle, …)

A Solution for All Reporting Needs

Publish &

Distribute Reports

File Server Email Printers MobileFTP Server

Generate

Reports

How it Works and What it Does

Dream Report Studio

Design &

Configure

Connect to

Data SourcesExisting Data Archives (Historians, SQL DB’s, CSV, etc.)

Real-time Data Sources(PLC’s, HMI’s, etc.)

Data Logger

Over 85 Drivers

Included!

Access to ALL your Data is Key!

and access to any SQL

database, CSV files, Excel,…

Combine all your:

Process, Lab, Quality,

Maintenance &

Operational Data

Integration with Wonderware Products

Direct, and Easily Integrated with System Platform®

Real-time

Historical

SuiteLink

MX + Galaxy Access

SuiteLink/OPC

Direct

driver

Direct

driverDirect

driver

Native

driver

WW SDK

& OData

Direct

driver

InTouch(local and

remote)

Application

Server

WW

Historian

Alarm

Logger

IntelaTracInTouch

LGH

DA

Servers

A2 High

Speed

Alarms

Historian

Online

InTouch

Machine

Edition

Native Driver

Dream

Report

The Benefit:

➢ Seamless Integration with

Existing Systems

➢ Supported & Sold by the

Wonderware Channel

➢ Certified and Endorsed by

Wonderware

A Complementary tool

with Wonderware’s Data

Analysis tools – InSight,

Historian Client, etc.

Integration with Other Aveva Products

Citect connectors:

✓ CitectSCADA real-time values & alarms

✓ CitectSCADA historical logs (trend files)

✓ CitectSCADA historical logs (DBF files)

✓ Citect Historian historical values

✓ Citect Historian historical alarms

ClearSCADA:

✓ Historical values

✓ Historical Alarms & Events

✓ Real-time Values

InduSoft connectors:

✓ IWS real-time (Native API)

✓ IWS historical values (ODBC)

✓ IWS historical alarms (SDK)

Calculations and Displays - Powerful and Easy

Single Data Object

configuration

All the Calculations & Statistics you Need

All the Calculations & Statistics you Need

This…?Or

this…?

Dream Report Portal - Secured Browser and Mobile access

Report Review, Generation, Dashboards, Manual Data Entry, & Ad-Hoc

Use “Out of the Box” or Customize for User Selections, Drill-down, etc.

Enable Your Team – Any User, Any Time, Anywhere

Manual Data Entry

Enables users enter and save “manual data” through the DRWeb portal

Simply create “web” reports >> data entry forms

Data can be corrected and validated by other users

Report on this data along with other process data

✓ Lab samples

✓ Operator comments

✓ Setup check-lists

✓ Manual readings

✓ …

EPA and State Reports

Monthly Operating Reports

Pumpage Reports

Lift Station Status

Lab Data Entry

Equipment Maintenance Reports

Energy Accounting

Critical Alarm Analysis

Automated Exception Reports

Water/Wastewater Reporting

Batch Reports

Dream Report can generate reports based on any Unit of Production

- Batch ID, CIP ID, Lot #, Work Order #, Roll ID, etc.

1. A Realtime or Historized Tag

2. From an External “Lookup” Database

Batch Time-Period can be retrieved

from:

Determines the relevant Start and End times, and

uses those in all objects and calculations on the Report

Can trigger the report by a real-time event (e.g., End-

of-Batch PLC trigger, HMI action, logical condition, etc.)

Drive down Operating &

Maintenance costs with predictive maintenance

Equipment & OEE Reports

Equipment Running time

Equipment Down time

On Counter / Off Counter

System Availability

Production KPIs

Conditional calculations

Dream Report has built-in functions to calculate:

Proactive Maintenance Reports - Automatic Report Generation

and Distribution

Generate and send report as soon up-time reaches pre-defined value

Generate and send service request upon equipment running time

Let system analyze and control maintenance of your equipment for you!

Secure Development, PC Browser and Mobile Support

User Management▪ Local or Windows-integrated user management

▪ Support Windows local or/and domain users and user

groups

▪ Extended user access control to reports and modules

▪ Localized language by User or Group

Version Control▪ Secure version ID stamp on reports

▪ Track user changes in secure database

▪ Ability to roll back to the specific (certified) version

Audit-Trail Recording

▪ Record all runtime activities

Electronic-Signatures

Version 5 – the Next Generation of Dream Report

Main Release Themes for Dream Report 5

Dream Report is no longer just a reporting tool – it

becomes a complete Information Platform

And it’s not only reporting - it’s also a modern

Dashboarding Solution

Version 5 – the Next Generation of Dream Report

New Features

True Interactive and Dynamic Dashboarding

www.dreamreport.com

Version 5 – the Next Generation of Dream Report

New Features

True Interactive and Dynamic Dashboarding

Custom and Customizable Graphical Script Objects

Analytical Data Server (ADS) - feed External Applications with

Data/Statistics/Calculations from Dream Report

Cost Calculation Module (support for Tariffs & Billing)

XML Output format for Reports

Version 5 – the Next Generation of Dream Report

New Features continued…

Electronic Signature support in Web Portal

Advanced ODBC Alarms driver

MQTT Driver – proving IIoT support

System Driver - Access to Internal System Information

Significant Performance Enhancements with Wonderware

Historian

And more…!

Thank You!

Let’s Start Reporting…

Our Goal Today:

Connect to Wonderware data sources and a PLC to build a plant

reporting solution with a Water Treatment report and a Batch Report,

highlighting the following Dream Report features:

Configure Communication Drivers for Real-time, Historical and Alarm

data sources

Use the Designer Studio to configure our reports

Automate the reports to be Scheduled and Event-triggered

Set up Manual Data Entry for lab data on our batch report

Use the DR Web Portal to view and dynamically generate reports

Web-enable our reports