[PDF] Dream Report Users Guide ver. 4.6 R4

View - Download Dream Report Users Guide ver. 4.6 R4

Previous PDF

Next PDF

Ocean Data Systems

i Dream Report

Dream Report®

Version 4.7

U

User Friendly and Programming Free

Reporting for Automation

http://www.dreamreport.net Copyright ©, All rights reserved, Ocean Data Systems Ltd.

Ocean Data Systems

ii Dream Report

Table of Contents

1. Help Documentation __________________________________________________________________________ 7

2. General Information __________________________________________________________________________ 7

Dream Report - Enterprise Information Integration and Reporting Software 7

System Requirements 8

Dream Report Installation Tips 10

Uninstall or Modify Installation 13

Project Upgrade Procedure 15

3. Licensing and Software Protection _____________________________________________________________ 19

4. Project Wizard ______________________________________________________________________________ 21

Project Wizard - General 21

Project Wizard - Project Name 24

Project Wizard - Connectivity 25

Project Wizard - Data Archiving 27

Project Wizard - Batch Definition 32

Project Wizard - Report Configuration 36

5. Project Settings _____________________________________________________________________________ 50

Project Settings - General 50

Project Settings - Database Configuration 53

Project Settings - Web Configuration 56

Project Settings - Folder Selection 59

Project Settings - Log File Settings 60

Hotbackup (Redundancy) Configuration 62

Project Settings - Localization 64

6. User Management ___________________________________________________________________________ 66

Project Settings - User Management 66

User/Group Authorization 70

7. Audit Trail__________________________________________________________________________________ 73

8. Report Settings _____________________________________________________________________________ 74

Report Settings - General 74

Report Settings - Report Name Format 79

Report Settings - Generation Time Definition 81

Report Settings - Generate Report on Event 83

Report Settings - Report Output Format 85

Report Settings - Excel Reports 87

Report Settings - Email Configuration 90

Report Settings - Printer Selection 92

Report Preprocessor 93

Report Settings - Macros 96

Report Settings - User Authorization 97

Report Settings - Advanced PDF Security 98

Table Of Contents

iii Dream Report

9. Logger Configuration Studio __________________________________________________________________ 99

Logger Studio Overview 99

10. Communication Driver Configuration __________________________________________________________ 101

11. Item Group ________________________________________________________________________________ 104

Item Group Definition 104

Item Group Definition - Logging Schedule 106

Item Group Definition - Log on Event 109

Alarm Group 111

Alarm Group Definition - Logging Schedule 113

Alarm Group Definition - Log on Event 114

12. Designer Studio ____________________________________________________________________________ 115

Designer Studio - Create new report 115

Rulers and Grid 117

Designer Studio - Static Objects 119

Designer Studio - Insert Picture 120

Designer Studio - Background 123

Designer Studio - Text Object 124

Designer Studio - Search and Replace 125

List of Dynamic Tokens 130

Using Dynamic Tokens in a Data Source Definition 132

13. Simple Statistic Objects _____________________________________________________________________ 134

Designer Studio - Single Data Object 134

General Functions: 136

Advanced Functions: 137

Performance Analysis Functions: 140

Energy Management Functions: 141

Batch Functions: 141

Set Point Analysis Functions: 141

Alarm Analysis Functions: 144

Direct SQL Query: 144

Pulse Analysis Functions: 145

Manual Input: 146

Designer Studio - Compound Data Object 148

Designer Studio - Expression Data Object 149

Advanced Visualization 156

Designer Studio - Batch Definition 157

Appearance - Result Representation 160

Alarm Filter Manager 169

Dynamic Text Object 170

Page Number Object 172

Advanced SQL Condition 173

Date & Time Object 174

Time Period Definition 176

Apply Correction Factor 179

14. Tables ____________________________________________________________________________________ 180

Item Table (Raw Values) 180

Free Table 183

Automatic Statistical Table 185

Designer Studio - Step Table 188

Ocean Data Systems

iv Dream Report

SQL Query Table 196

SQL Query Manager 197

Designer Studio - Alarm Table 202

Table Footer 206

15. Charts and Graphs _________________________________________________________________________ 208

Pie Graph 208

Bar Graph 212

Line Chart 220

Indicator 230

16. Dynamic Interactive Objects _________________________________________________________________ 235

Timestamp Picker 235

Hyperlink 237

Combo Box 240

Action Button 247

Tree Object 253

17. Report and Page Templates __________________________________________________________________ 255

Page Templates 255

Report Templates 257

18. Tools _____________________________________________________________________________________ 262

Tag Dictionary 262

Setpoint Stability Analysis 265

Custom Archives Import Tool 269

Virtual Report Instances 271

DBatch 274

Database Archiving 281

Aggregated Data Filter 284

Multi-Tag Aggregation 287

Pivot Groups 292

Pivot Tables (SQL Table Row Grouping) 295

Project Deployment Tool 298

Dynamic Objects Selection 299

Electronic-Signature 300

Data Modeler 306

FTP Transfer Engine 310

19. SPC Module _______________________________________________________________________________ 313

SPC Configuration 314

SPC Control Charts - X-bar, R and S 315

Histogram Chart 319

Histogram Table 321

Process Value Table 324

SPC Statistical Functions 326

20. SQL Development Tools _____________________________________________________________________ 327

DSN Manager 327

Edit SQL Query 329

SQL Query Manager 330

Visual SQL Query Designer 332

Table Of Contents

v Dream Report

21. Runtime Manager __________________________________________________________________________ 333

Runtime Management Console 333

Runtime Configuration 342

Dynamic Report Generator 344

22. Communication Drivers _____________________________________________________________________ 352

List of Communication Drivers 352

Data Source Definition 357

Supported GE Intelligent Platforms Software 361

Cimplicity historical values driver 362

GE Proficy Historian Historical Messages driver 364

GE Proficy Historian Historical Values driver 367

iFix Native real-time values driver 371 iFix Native real-time alarms driver 372 iFix Native historical values driver 373 iFix Native historical alarms driver 375

ODBC Driver 376

Excel Data Import Driver 380

OPC Drivers 387

Modbus Communication Driver 392

Analytical Driver 396

Web Manual Driver 397

Rockwell RSView Historical Values Driver 399

InTouch Native Driver 401

Wonderware OPC Driver 404

Wonderware Historian driver 408

InTouch Historian Driver (LGH files) 411

Wonderware WWALM Historical Alarms Driver 413

WW Historian Alarms Driver 417

OPC Offline Driver 420

Eurotherm Review Communication Driver 422

PcVue Communication Drivers 425

Control Maestro (legacy Wizcon) communication driver 432

LUA Script Historical Data Access driver 433

Kit of Simulation drivers 436

Communication driver development toolkit 440

23. Remote Connector _________________________________________________________________________ 441

Remote Connector Server 441

Remote Driver Connector 443

24. Web Portal ________________________________________________________________________________ 445

Dream Report Web Portal 445

Web Manual Driver 454

Manual Data Entry 456

IIS Configuration on Windows Vista 458

Manual Configuration of IIS 459

25. Dynamic Interactive Objects _________________________________________________________________ 470

Timestamp Picker 470

Hyperlink 472

Combo Box 475

Action Button 482

Tree Object 488

Ocean Data Systems

vi Dream Report

26. Index _____________________________________________________________________________________ 490

Ocean Data Systems

7 Dream Report

Help Documentation

General Information

Dream Report - Enterprise Information Integration and Reporting Software

Dream Report is professional software for industrial automation, for real-time data and alarm acquisition, logging to

the database as well as data analysis and advanced reporting, based on Dream Report database or any other

external history data server. Dream Report is out-of-the-box Reporting software for the Automation Market which: Directly collects Alarms and Raw Data from multiple heterogeneous Data Sources such as I/O, PLC,

RTU, SCADA, DCS, MES, etc.

Leverages all archives from other solutions and applicat Aggregates and logs to any standard Database all alarms and Data collected facilitating Information Integration within Manufacturing and Enterprise applications

Integrates in one user-friendly environment all tools to easily create and generate automated Reports

Enables Print, Archive, Email and Reports Publishing over the Web automatically Is intuitive requiring only one-day training and assimilation Compatible with any application in all Vertical Markets

Runs in a fully secured multilingual environment

Provides an extra tool (Dream Report Project Creating Wizard), that helps to create a turnkey simple project, which can be later edited and developed in the Dream Report Studio To learn how to configure data logging, please, refer to Logger Studio section.

To learn more about database configuration and maintenance, please, refer to Database Configuration section

To learn more about report graphical design, please, refer to Designer Studio section.

To learn more about report configuration and/or report automatic generation and distribution, please, refer to Report

Settings section.

Ocean Data Systems

8 Dream Report

System Requirements

Hardware Requirements

CPU: Dual Core 2.4 GHz+

RAM: 8 Gb+

HDD: 500Mb (for installation) minimum, 7200 rpm or higher (or SSD)

Video adapter: Minimum memory 128 Mb

Network adapter: No special requirements

Monitor resolution: 1280x768

Operating Systems Supported

Windows 2003 Server (incl. R2)(Web Portal requires Service Pack 2) Windows Vista (Web Portal requires Service Pack 1 and higher) Windows 2008 Server (incl.R2), any SP and (32-bit) and (64-bit) Windows Server 2012 (incl.R2), any SP, (32-bit and 64-bit editions) Windows 7 (32-bit) and (64-bit) with and without SP1 Windows 8 Professional and Enterprise (32-bit and 64-bit editions), incl. SP1 and SP1 R2

Windows 8.1 Professional and Enterprise

Windows 10

Databases Supported

MS SQL Server 2005 Express, 2008 Express, 2012 Express (using ODBC SQL Native Client 11) , 2014

Express (using ODBC SQL Native Client 11)

MS Access 2000, 2003, 2007, 2010, 2013

MS SQL Server 2005, 2008 (incl. R2)

MS SQL Server 2012 over ODBC SQL Native Client 11

MS SQL Server 2014 over ODBC SQL Native Client 11

MySQL 4.x and 5.x versions over ODBC driver 3.51, 5.1

Oracle 11 over Oracle XE ODBC driver

Web Browsers Support for Web Portal

Internet Explorer 9 and higher (IE 11 recommended) Edge

Chrome

Mozilla

Opera

Mobile Operating Systems

The Dream Report Web portal is supported in a web browser on Android, iOS (both iPad and iPhone) and

Windows Phone 8.1.

Ocean Data Systems

9 Dream Report

Additional Software Requirements

To visualize PDF files you need to install Adobe Acrobat or other PDF viewer (the latest versions are

recommended)

To use Web Portal, you have to install a web server (Internet Information Server or other) before Dream

Report® installation.

.NET Framework 3.5 and .NET Framework 4.5 or higher has to be installed before Dream Report® installation. If you want to use DRWeb Portal, please install a web server (Internet Information Services) before

installing Dream Report. For additional information on configuring IIS for use with Dream Report, please

refer to the Web Portal section

For a complete list of supported operating systems and databases for all versions of Dream Report, please refer to

the following Compatibility Matrix:

Online Help:

The online help contains detailed description about most of Dream Report functionality and is available in 3 different

ways.

It can be loaded:

Pressing F1 in Dream Report studio

From menu Help in Dream Report Designer Studio

From start menu in Windows (Start-->Programs-->ODS-->Documentation-->Dream Report Online Help)

Contact us to buy:

sales@dreamreport.net

Contact our technical support:

support@dreamreport.net For any other information, please, visit our web site: www.dreamreport.net

Join our LinkedIn groups:

https://www.linkedin.com/groups/7450756

Ocean Data Systems

10 Dream Report

Dream Report Installation Tips

Installation of Dream Report

Prerequisites

Before installation user has to ensure that the following list of components is installed on the target computer:

1. Microsoft .NET framework 3.5 or 3.5 SP1.

2. If user plans to run the Dream Report embedded web portal, then IIS (Internet Information Services) feature

has to be installed on the computer.

3. It is recommended to close all running programs due to the fact that, at the end of installation, user will be

asked to restart the computer.

Installation process

In order to start Dream Report installation, please use the CD (supplied by Ocean Data Systems) with the

product installer or download the product from the Dream Report corporate web portal.

1. Run Dream Report setup executable.

2. Accept the license agreement.

3. Select all required components from the Features Tree (including required communication drivers).

4. Wait while the product installation process is completed.

5. Restart the computer.

Here are some installation tips, which we ask you to read before installing:

Selection of Communication Drivers.

When installing Dream Report, it will automatically install only 4 basic drivers: OPC, ODBC, Analytical and

Simulation drivers. If you need to use any other drivers in your project, then, during product installation, when

you come to the "Select installed components" window in the installation wizard, you will see a tree of

installed components and communication drivers. There you have to expand a Communication Drivers branch of that tree and select (check) all drivers, which you may need when using Dream Report.

Web portal

During Dream Report installation, the installation wizard will check if Internet Information Services (IIS) are

installed in your operating system. Together with IIS you have to ensure that all ASP.NET related

components are installed (please refer to Manual Configuration of the IIS guide). If IIS is not installed on

your system, then the Web portal and all related components will not be installed. In this case you will get a

prompt message that IIS installation is not found, and the Web portal will not be installed, and if you wish to

continue product installation.

If you do not intend to use Dream Report web portal, please, click "Yes" and the product installation will

continue without installing Web portal. If you do intend to use Dream Report web portal, please, click "No",

exit Dream Report installation, install IIS and after that install Dream Report.

If you have installed Dream Report without the web portal and afterwards you have installed IIS and you

wish to start to use the Dream Report web portal, you have to uninstall Dream Report and then install it

again. During new installation, Dream Report installation procedure will recognize that IIS is installed and

then all relevant web components will be installed.

Ocean Data Systems

11 Dream Report

Additional installed components (OPC Core Components and Visual C++ Runtime)

During installation of Dream Report, one of Dream Report installation wizard sections is "Select installation

components". In this section you will see a tree of components, available for installation, including Dream

Report designer studio, Communication drivers and others. This section also has two custom components in

that list: OPC Core Component and Visual C++ 2005 Runtime Redistributable. Please, check why and when

you may need them:quotesdbs_dbs23.pdfusesText_29

[PDF] Cartographie avec R - Baptiste Coulmont

[PDF] RecheRche d 'emploi comment créer mon cV - Pôle emploi

[PDF] 8- Import-Export de données

[PDF] Plan analytique structuré - Infologik

[PDF] Logiciel de création de patrons, de gradation et de - Maugin SAS

[PDF] Tutoriel Adobe Acrobat Pro Créer les fichiers PDF de la thèse

[PDF] grossesse - Douce Naissance

[PDF] Fiche procédure Utiliser PDFXChange

[PDF] 2 Guide Campus France Maroc 2016-2017 2- Je crée mon compte

[PDF] Comment créer mon espace sur impotsgouvfr Ouverture du compte

[PDF] IZLY COMMENT ACTIVER SON COMPTE Objet - IUT de Tarbes

[PDF] creation d un cours sur moodle - Plateforme pédagogique de l

[PDF] Exercice - Créer un dépliant 3 volets

[PDF] Tutoriel pour la création d 'un site web - Google Sites - Challenge Fly

[PDF] Photoshop Séquence 5 - Créer un logo - Créer une image pour l