COURSE DESCRIPTION
The Dream Report Fundamentals technical training course is 4 days, hands-on instructor-led class designed to provide students with a fundamental understanding of the Dream Report reporting software. Dream Report is the leading programming-free, user-friendly reporting solution specifically for industrial automation. It was designed to be the simplest solution to extract data from almost any control system (PLC's, HMI's, standard protocols), process Historians, and open databases, and automatically provides reports to anybody, anywhere. The instructor is a Dream Report expert, who brings extensive real-world experience in implementing reporting solutions to the training class.
OBJECTIVES
Upon completion of this course, you will be able to:
- Configure Dream Report to extract data from almost any data source
- Design and create reports
- Automatically generate and distribute the reports
- Utilize Dream Report's productivity and data archiving tools
- Interact with the reports through the DRWeb portal
AUDIENCE
This training is for end-users, system integrators, engineers, and technical professionals who need to configure and use Dream Report for plant and process reporting applications.
PREREQUISITES
- Basic PLC experience
- Manufacturing industry experience
- Familiarity with Personal Computers and the Windows operating system
COURSE OUTLINE – DREAM REPORT
|
MODULE 1 INTRODUCTION – PRODUCT ARCHITECTURE AND INSTALLATION
Section 1 – Dream Report Product Overview
Section 2 – Installing Dream Report
Section 3 – Creating a new Reporting Project
MODULE 2 COMMUNICATION DRIVERS – CONNECTING TO DATA SOURCES
Section 1 – Communication Drivers Configuration
Section 2 – Configuring OPC Driver
Section 3 – Configuring ODBC Driver
Section 4 – Configuring Simulation Drivers
Section 5 – Configuring Vendor Specific Drivers
Section 6 – Overview on the Overall Communication Drivers Library
MODULE 3 – LOGGER STUDIO – CREATING LOGGING GROUPS
Section 1 – Creating Logging Groups
Section 2 – Logging Database
MODULE 4 – REPORTS AND REPORT SETTINGS
Section 1 – Adding a New Report
Section 2 – Report Templates and Page Templates
Section 3 – System Fields: Date/Time, Page Number, and Dynamic Text
MODULE 5 – SIMPLE STATISTICAL OBJECTS
Section 1 – Single Data Objects
Section 2 – Compound Objects
Section 3 – Expression Objects S<
Section 4 – Single Data Object Expression or Widget
MODULE 6 – ADVANCED SQL CONDITION
Section 1 – Using Advanced SQL Condition for Statistical Objects
MODULE 7 – TIME PERIOD DEFINITION
Section 1 – Absolute and Relative Time Periods
MODULE 8 – BATCH REPORTS
Section 1 – Creating Batch Definitions
Section 2 – Batch Based Time Definition
Section 3 – Batch Information Statistical Functions
MODULE 9 – TABLES
Section 1 – Item Table
Section 2 – Alarm Table
Section 3 – SQL Query Table
Section 4 – Step Table
Section 5 – Automatic Statistical Table
Section 6 – Free Table
MODULE 10 – LINE CHARTS
Section 1 – Adding Line Chart
MODULE 11 – BAR GRAPH AND PIE GRAPH
Section 1 – Bar Graphs
Section 2 – Pie Graphs
MODULE 12 – INTRODUCTION TO QUICKSCRIPT.NET
Section 1 – Introduction to Scripting
Section 2 – Variables and Control Statements
MODULE 13 – DATA MODELS
Section 1 – Data Modeler
Section 2 – Configuring a Data Model
|
MODULE 14 – MULTI TAG AGGREGATION
Section 1 – Multi Tag Aggregation Configuration
Section 2 – Using a Multi Tag Express in a Reporting Object
MODULE 15 – EXPORT REPORTS TO EXCEL
Section 1 – Define Exporting Report Data to Excel
MODULE 16 – USER MANAGEMENT
Section 1 – Add Local Users
Section 2 – Using Windows Users and Users Groups
Section 3 – Assigning User Access Rights to Dream Report Modules
Section 4 – Assigning User Rights to Different Reports
MODULE 17 – REPORT & CONCURRENT PROJECT DEVELOPMENT
Section 1 – Project Repository
Section 2 – Upgrading a Dream Project to a Configuration Database
Section 3 – Repository Based Project Development
Section 4 – User Management with Repository Based Project Development
Section 5 – Remote/Concurrent Project Development
Section 6 – Locking/Unlocking and Committing/Updating
Section 7 – Running a Repository Based Dream Report Project
Section 8 – Remote Project Development
MODULE 18 – WEB PORTAL
Section 1 – Configuring the Web Portal
Section 2 – Using the Web Portal to Generate Reports
Section 3 – Slide Show Mode
MODULE 19 – WEB-ENABLED REPORTS
Section 1 – Web Report Target
Section 2 – Web-Specified Display Options
MODULE 20 – WEB OBJECTS AND WEB FORMS
Section 1 – Using Date/Time Pickers
Section 2 – Using Hyperlinks
Section 3 – Using Combo Boxes
Section 4 – Using a Tree Object
Section 5 – Using Buttons
MODULE 21 – WEB MANUAL DRIVER AND MANUAL DATA ENTRY FORMS
Section 1 – Adding Manual Parameters
Section 2 – Validation Rules
Section 3 – Submit Manual Data
Section 4 – Correct Manual Values
Section 5 – Validate Manual Data
Section 6 – Report on Manual Data
MODULE 22 – DASHBOARDS
Section 1 – Dashboard Designer Studio
Section 2 – Drill Down Dashboards
Section 3 – User Filter Objects
Section 4 – Dashboard Integration with Dream Report Web Portal
MODULE 23 – REPORTING DATA SERVER
Section 1 – Configuring the Reporting Data Server
MODULE 24 – CUSTOM GRAPHICAL OBJECTS
Section 1 – Designing Custom Graphical Objects
|
| |
|
|
What's New in Dream Report 2020 R2
|
General Overview of Dream Report – (12 Minutes)
|
|
Create a Report in Under 5 Minutes – (5 Minutes)
|
Dream Report Success Stories – (20 Minutes)
|
|
Configuration and use of the Dream Report Notifier feature – (6 Minutes)
|
Overview of Advanced Alarm Analysis in Dream Report – (10 Minutes)
|
|
Interactive Web Portal – (34 Minutes)
|
Statistical Process Control (SPC) in Dream Report – (18 Minutes)
|
|
Deeper Dive into Statistical Process Control (SPC) in Dream Report – (54 Minutes)
|
Automatic Statistic Table Object – Quick Data Aggregation & Analytics – (8 Minutes)
|
|
Remote and Concurrent Configuration with Dream Report – (27 Minutes)
|
Clean In Place – A Batch Reporting Example – (9 Minutes)
|
|
Dream Report Connects to Remote Data – (9 Minutes)
|
Automatic Statistic Table Object – Quick Data Aggregation & Analytics – (8 Minutes)
|
|
The Various Methods of Connecting Dream Report to SQL Data – (7 Minutes)
|
Accessing Data from SQL Databases with Dream Report – (15 Minutes)
|
| |
|