Dream Report®
Contents
1. Page Template You can select an existing page template to apply to the current page then it will add all template elements to the report page without any damage to the existing report content and each template element pictures background graphic objects etc will be available for editing as independent objects Or you can create page templates to be easily used later within the reports A page template is similar to the headers and footers of a page in other software Home Connectivity Project Web Elements 43 Copy Object mia m mm 74 Paste Object i Insert iB Z New Page Clipboard Quick Lau IN Save As Agia Save As Page Template Template B E Apply KL Apply Page Template Template List of I Driver amp Cut template wee M A page template will save all static objects including images pictures backgrounds static drawings static text and some dynamic objects such as page number dynamic text and date time If you save any existing report 2llPage S Dream Report page as a template all static objects will be saved and all dynamic statistic and analytic objects will be ignored Report Template You can select an existing report template and configure settings for it Or you can create templates of entire reports to be used for creating other reports ALE a Home Connectivity Project Web f N L T VL f Paste Object IE Fr Page Insert amp2. Ocean Data Systems Ltd The Art of Industrial Intelligence Dream Report GETTING STARTED User Friendly Programming Free Reporting for Automation http www dreamreport net Copyright R Ocean Data Systems Ltd All rights reserved Dream Report Table of Contents 3 Welcome to Dream RED OE bent sia pun Gradxm ie m IERI bera Mmi Or pa depdE 3 About this document a csiecucecer a Gus sur rco AE EATE a ea osse Ure ad vL E Kb N AP od E eEEG A 3 APO DS SONG 4 FORESTS Ora 1 4210 4 Dream Report Product ee nore eee eee Oe ee ee 5 Dredm Report ercran 5 System Requirements 6 EU E UTI EM MEER TUENTUR UE UT nics E E N 7 For MOLE IO 6 8 PUTO P E E ETE EE E PEE E A 8 Chapter 1 Creating a Project in Dream Report sssessssssssessresssreresrresssreresrresssreresererssreresererssreresererssrereseeeesseeeo 9 Step 1 Creating a New Proje ct cccscccssccseccseccescesecesccesccesecesecesecesecesecesectaeesseetseetaeetseetaeeteeesesseeeseetes 10 Step 2 Configuring Connectivity and Communication ccccceseccccessececeesececceeceeeeuseceesueceeseneceeseeeeeeeas 14 Step 3 Data Alarms Logging optional cccccccccccccccccssceeeseeeeeceececccccsceseeeeeeeueeesesseeeeeececessseeeeeeeeuaagegs 15 Step 4 Batch m 17 Step 5 Configuring a Report cccccccssseccceeseccccesscceceescceceueceeeeeecceseusecessuneceee
3. 2 J ET vet B text dee 8 es io B vve ve 8 rece Slee Sis B Bie 1 Enter Instance name has to be unique for that report 2 Select required data sources and items tags for each dictionary entry 3 Click on Add button The defined instance will be added to the List of defined report instances 4 Find and replace data items if you need Creating virtual instances enables users to e Set separate generation schedule for each instance e Set separate generation event for each instance e Select manually tags for report at generation time 32 Page Dream Report CUSTOM ARCHIVE IMPORT TOOL Use Custom Archive Import Tool to access any available external archive using any defined HDA driver and periodically import its data values into the Dream Report internal database which makes the data available for reporting from the standard Dream Report database please see the picture below Custom Archive Import Tool Configurabian 1 Select Data Theme Selected List feng g OBE bd m Galact Data Tans Bach Data Prionty Clingert atens P m 1 Put a logical name of the import definition into the Name edit box Import definition name is unique and can t be the same for multiple import definitions 2 Select the history access data source which will point to the needed external archive 3 Select data items which values you need to import All the selected items will appear in the Selected List of Data item Na
4. Dream Report Miebory S External History Server j Odie Source m ODE Him Hanes m Batch Date Temp Prasat Bach Das Bach ID 11 Tosa Dg 1 yl Process Batch Osia Hu x n Process Batch Date Kotor xj 4 Process Bach Lister ank 3 34 E F Lo a Bonide Db ximo T cen E eu Cartel Note Changing one tag in the project tag dictionary will modify all related objects where that tag has been used Project Tag Dictionary the list of tags is e Global for the project i e includes all tags which are used in the project and their descriptions optional e Printable and easy accessible 35 Page Cy Dream Report I DSN MANAGER Use this functionality to manage configuration of all DSNs used in the project from one place please see the pciture below DSN Manager x OSM defintion nami Lise DSN Login Process DSN Stable Proceso admn aaa Add D 5 N Lise DSN test batch data hea OK Cancel 1 Enter DSN definition name has to be unique and will be used in further work with that DSN within the project 2 Specify Login and Password 3 Click on Add button The DSN definition will be automatically added to the list of project DSNs 4 Click on Test button to check if the connection to the selected DSN succeded or failed 5 Click on Add DSN button to add a new DSN to the project 36 Page S Dream Report DATABASE ARCHIVING Use this functionality for periodic archiving of the Dr
5. Ott Ferlormance and Maintenance E Eg Production and Manulacturing List of Report files maepart Refinery 2 l l 1 E z Be Gg Ae porting Obprscts Fames 2012 03 ig 5 Setpoint Analysis in ul Walter A Waste Water b li 2 Web Reports Pruduwrtinn 23 X3 13 LH 4H 2 pdf n Report Prodection 23 Kt 13 iH dd 43M a b Copyright All rights reserved NOTE To have access to a project in the Dream Report Web Portal each time a new project is started you will have to configure IIS Internet Information Services for that project manually For this you should click on the Configure IIS button either in the Web Configuration dialog box of the Project Settings section in the Dream Report Studio or in the Runtime Management Console dialog window 3llPage S Dream Report CHAPTER 4 DREAM REPORT ADVANCED TOOLS This chapter describes different modules which you may use in Dream Report to serve your needs for precise and advanced performance of our product t VIRTUAL REPORT INSTANCES Use Virtual Report Instances to create multiple pre defined instances of the same report template where each instance will use the same template with different pre defined tags please see the picture below Vaud inpet nd eee ony faq twee bA 1 t faba vd is siwon es An wa at te wart agp tat n Leng por paora Hey mom feat Cem Date unt LL doe rears and ur te _ D Cecpan Daa Soga ter Now Fur J
6. Settings i ta ok Md Rd tae cal Pilate amp amp cut hemglabe template Hew Page mW t a a ECE a ZA Fali Screen Cipbpsard Praject Font Text Align Crime Aligeanient Pulers and Grid Quirk U i r i umm ue p E a Craver Lint of Fpesdtir 23i Propect Report s Lis Md 5 5 Energy Productien zu T Water Report E Water Tiir Bun Propet Reload praject F Relami reparti Edm prajexi E Denaren Obpecis v R Step tables Wi ao UHH Inport lilt tn Tool Single Data Object enables to extract Current value Last Min Max Average Sum Duration Up Down Availability Deviation etc Compound Object enables to select predefine statistics and extract easily Min Max Sum Average and Standard Deviation Expression Object enables to do calculation based on Trigonometric Mathematical and Boolean instructions Item Table enables to display an array of values from one or more data items within a specified value range which were logged during the specified time period Alarm Table enables to define alarm filters groups and display them in a pre formatted table SQL Table enables to define the SQL Query and visualize the result as a table with predefined parameters 23 Page NY Dream Report Automatic Statistical Table enables to select any period define a step and select the statistics to be calculated and displayed Step Table enables to create t
7. storage V Umit number of stored files Store files for period of 19 Page S Dream Report A Report Name define the name for your report You can also configure storage and maintenance of report files in the General section B Report Name Format define how file names for an output file will be generated the report file naming rule will be applied both to PDF and Excel report files C Report Time Format define an automatic report generation schedule generation on schedule or cyclic generation D Report Generation on Event configure an event based report generation and define different generation rules on event for different report instances E Report Distribution configure report output settings i e what format the report will be generated in and how and to whom it will be distributed F Preprocessor optional define the performance of an action SQL query or stored procedure before report generation using input parameters and use the result as an input for report e g as a list of tags G Macros optional define and attach a list of macros to each report separately and run it when the report is generated or on event H User Authorization optional define access rights to each specific report for specific users A TIP The configuration of all reports in the project can be changed in one window without closing and reopening it again Clicking on another report in the tree in
8. Conmecthity configuratii General q Looper Sudo Group Mame n Dats tema Current Value H Driver il Lagging data item grouns Configuration D Ceia i Group Desciplion i C Data 2 Gipu Souni 5 Analytics Add data source Reload project aei 8 Legging alarma groupe ee PT asirms i E a oma Aw 1 Define general properties of a group logical name short description if needed data source to include items into the group data items for the group 2 Select the logging mode and the logging schedule for the entire group 3 If you need to log data on some pre defined condition use this section Record Rate to define this condition Then the values of items from the entire group will be logged only if this pre defined condition is true Note If the group logging schedule is defined that data will be logged only when the logging period is active and the event is TRUE If a group has no schedule defined then data will be logged when the condition is TRUE 4 Click OK and the data item group will be configured for logging A TIP Use the same procedure to configure alarm groups for alarms logging 16 Page S Dream Report Step 4 Batch Definition optional If your report is for a batch process process loop where the exact time period and duration are not known in advance you can use the batch mechanism of Dream Report Batch can be defined in Dream Report in 2 ways 1 By data item i
9. Cut emplate template New Page Clipboard RE Ww Save As Report Template f Quick lau A LI in p p mmm B Ne Apply Report Templat r pply Report Template Li Driver 43 Copy Obje It can be used later to build similar reports A report template will save all static dynamic statistic and analytic objects within the report but also will include report settings and Excel report configuration 2 You can add static objects static texts bitmap pictures background images and colours or define settings for rulers and grid to your report using the toolbar buttons or the Designer menu in the Report Designer Studio e Oe 7 Home Connectivity Project Web Elements Tools Runtime he M M Iv fe Arial European 8 i Repot Page inet B Z ME 3x 3 temp te template New Page V A A A mc Projert Fort Text Atignment Ir m 4 Grid Settings gt f OP 4 n we Sls Rd D MEL Eri mE ejl XC B Fut Screen Rulers and G IM Paste Object Clipboard 3 In the Dream Report Designer Studio Elements toolbar you can select the dynamic objects which will display your extracted data 22 Page y Dream Report DF Heme Connectivity Project Web Elements Took Runtime Help 23 Objet L mum 975 iem IN AnabjEuinpean i EE RIA X OOS E447 ow dicU i MIL H A Paste Object 7 E E A mx E E EE z TA Grid
10. Report embedded web portal c Deactivate UAC User Access Control It is recommended to close all running programs due to the fact that at the end of installation you will be asked to restart the computer 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 http www dreamreport net Run Dream Report setup executable Accept the license agreement Select all required components from the Features Tree including required communication drivers NOTE 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 will have to expand the Communication Drivers branch of that tree and select check all drivers which you may need using Dream Report If you don t select the other drivers which you may need in the project at this stage then you will not be able to select them later And your project will run only with 4 basic drivers configured by default 7T Page S Dream Report 7 Wait while the product installation process is completed 8 Restart the computer For more informatio
11. able automatically with a predefined time for each row in the table Free Table enables to build customized tables mixing text dates and statistics Pie Graph enables to compare and display alarms or statistics current last Min Max Average in a pie chart Bar Graph enables to display alarms or statistics by period in a bar graph Chart enables to display multiple statistics in charts Indicator enables to display calculated data in the new representation way according to the latest energy reporting standards Date and Time Object enables to display a dynamic date and or time in the desired format with a pre defined offset if needed Page Number Object enables to display the number of the current page or the total number of pages in a report Dynamic Text Object enables to display the text in a report where the value is determined during report generation 4 In the Dream Report Designer Studio Web Elements ribbon you can select the dynamic interactive objects which will be available ONLY in web report formats in Dream Report Web Portal and will enable users to interact with different report data enter values select values from combo boxes push button with a pre defined operation and others 24 Page S Dream Report Home Connectivity Project oo e E F po BH let Hyperlink Action Combo Timestamp Box Picker Dream Report offers the following types of web elements available for Web
12. al 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 Folders Organization By default Dream Report installes itself in C Program Files ODS Dream Report If you use Windows 7 then Dream Report will install itself in C ODS Dream Report It also installs the following folders Clipart Library of Icons Images and Report Backgrounds Database Multilanguage file Lexicon mdb and LexiconWeb mdb Documentation Release Notes with the latest information about the new Dream Report release and Getting Started User Manual with the main guidelines on how to use the Dream Report product DR Web Portal Web configuration files Help Dream Report Online Flash help files License Dream Report license Project All projects saved by default Systems System application files Templates All templates saved Utilities Some utilities Adobe Reader OPC Core component SQL Server HASP driver etc 4 Page o Dream Report Product Overview Dream Report Architecture Fast and easy access to any report of the current project from any site Dynamic generation of reports on demand in real time Web based manual data entry reports design and manual values entry Generating new reports on demand Dream Report Via email to the recipient s
13. button When you start a new project you can use this option to help you configure basic settings for your project The Dream Report Project Wizard tool will assist you in creating a simple project in an easy way and then you will be able to continue your project development if needed in the Dream Report Designer studio in a normal working mode lO lPage S Dream Report Dream Report Project Creating Wizard M Project Name B This Wizard wll help you t create a tum key simpla project which you can edit and continue developing in Draam Report studia Connectivity ra d UC You can siop and exit this wierd at amy step wsbout axecutlm by PP Archiving a Clocking Closes button u Button Next will bring you to the next step and button Back can bring Batch c Pyou ana step back to ra configure It or check Hs configuration Reparts Good hick A Define the name of your project and select the PC folder where the project configuration files will be saved the folder will have the project name you have entered B Connect to any data source and acquire live data alarms or access its history C Configure data logging into the Dream Report internal history database if needed D Define batches if your report is for a batch process if needed E Configure output properties for your project report 2 Define general project related information project name author and description optional i
14. e output properties of your report To configure report Dream Report settings right click on the report tree in the Report Designer Studio and select Report Settings from the context menu Ts Delna Vertue Report Iritana Apply Page Template Apply Report Templste Save fe Page Template Save Rz Report Tempiste Copy Rect To Folder Delete Report The Report Settings dialog window will be opened The left tree will contain a list of reports that will be defined in the project Panels on the right will display settings for the selected report in the tree If the report selection is changed the panel will be updated with data from the selected report Report Settings Project Report s List Alarm Tables Automatic Statistical Tak Report Bacteriological Report Bar Graphs Batch Info Report Batch Trend Charts Data Tables Demo Batch Report Energy Effidency Repor Equipment avaiabiity re Fluoride Monthly Report GW Monthy Operating F Indicators Monthly Operating Repo Pie Graphs Report Energy Report Maintenance Report Production Report Refinery Report Water Setpont Analysis Single objects SQL Tables Step Tables Turbidity Report Web Trend Vidgets Alarm Tables Description of Report Report storage V Copy report files to folder 82 233 437 73 Reports C Windows folder FIP User authenticaton Logn Password login ETIT Test Create yearly subfolders Create monthly subfolders Limit report files
15. eam Report database in order to improve data logging and report generation performance please see the picture below Database archiving configuration dialog Enable database archiving 1 Maximum age of data which you want to keep in the main databas 1 year s 2 Archive aged data every Al 1 month s z Every Folder where database archive files will be storeg C 005 Pream Report Project Demo Database anual operations Edit archive library Define maximum data age to be kept in the project main database Select frequency and schedule of performing archiving operation Select folder where database archive files will be located Perform one of the following manual operations Archive now will trigger archiving operation immediately or Edit archive library will manually register new archive files immediately AuUu N B P 37 Page S Dream Report Y AGGREGATED DATA FILTER Use this functionality to connect to any external history HDA data source and perform smart data retrieval please see the picture below Aggregated Data Filter s List ADF Configuration Aggregated Data Filter P 4 Cydic Aggregated Data Filter Type Agg egated v Aggregated Data Filters Settings i 4 Retrieve Average vaue For every t 1 Enter ADF Name 2 Select ADF type Sample based or Aggregated 3 Select ADF filtering options type of data retrieval and time period for da
16. eueceeseeecessusecesseneceeseneeeetas 18 Step 6 VersiameoltvrOlconssteei E esi DEMENS me LII LM Mu TU EN 20 SEED 7 DeSIBHIhE 9 BeDOPD oo beer d adetrEad Praia dad asus an CIN ROS NR nee sie aM da UD AM NI HM UU 21 CHAPTER 2 DREAM REPORT RUNTIME eeeeeeeeeeeeeenn nennen nnne nnne nennen nnn nennen snas enn sees sess asas n nnne ens 26 CHAPTER 3 DREAM REPORT WEB PORTAL wrisisissaccncasesasvedeteecndsveseveceeteeanebensescedinbansubentnsscsenbesdeaavessalicbabesassnvess 29 CHAPTER 4 DREAM REPORT ADVANCED TOOLS PP 32 VIRTUAL REPORT INSTANCES cicna erann na e a ER Ea a ERU vcnio bus aE 32 CUSTOM ARCHIVE IMPORT TOOL sccccccccssesssssceeccccsseessseeeecccesseeussceececeessaeeuseeeeeeesseuauseeeeeeseesaagaasess 33 SETPOINT ANALYSIS 34 TAC BDI TONAR ne 35 BUNC lm c 36 DA EAB ASE iiec OH 37 AGORECGATED DATA FILTER iren doutes deter EEE haa adus inet dpa rade p p hus deibat 38 CustomBr a 0 0k el conan tn rte TERI VPE EAM VIP tu MEN E M NE 38 NY Dream Report Preface Welcome to Dream Report This document will assist you in creating a project in Dream Report in a simple and easy way and will introduce you briefly to the Dream Report tools and the most important Dream Report functionalities Abo
17. f the batch ID is taken from a tag value from a real time driver and its value is logged into a Dream Report database 2 In External Database if the batch ID is taken from an external database then please select the database where batch information will be stored During report generation Dream Report will automatically go to the database analyse the values of a tag defined for the batch recognize the start and end times of the batch and will then apply those times to the object Babch definstusn Defined hatches Energy 8 Defined by data tem Dets bem For Beton IL Deka Source Dream Report Fietory External Hisbory Server Dat a Ik BT Eckch Deka Tank 5 Defined in etena database select Data Location Configure Database Connection Galact Tabla Sect DN Field 5h Batch DO Liser rere Fek ath Babeh Start Tia Fazer Feld ath Baith End Time Select Golden Bstch i gt DK 1 conc 17 Page S Dream Report TiPs Each batch process is marked by a unique ID and this ID will be used later to recognize and distinguish batches process loops So in order to track batches define the source for batch IDs Dream Report batch definitions allow tracking batch IDs by a tag from any real time data source or retrieving them from an external database in different formats Step 5 Configuring a Report Once you have created a new project and have configured connectivity to the data sources
18. ing the project reports shutting the project providing access to different project options project folders Web portal IIS configuration Dream Report license info help documentation report generation on demand while the project is running This chapter describes the mechanism of running Dream Report project s logging data and executing report s Dream Report Runtime Manager enables e Data logging Standard dynamic report generation Multiple runtime options 26 Page Dream Report Als Pe x al nj Batch reports Batch nfo Report E Demo Batch Report i Local T Connect i Energy Report exarmngles 11 71 43 Batch Info Report Waiting Resorts Queue WA nergy Efficiency Report Report Energy Hg GEE Performance and Mamtenance Equipment availability report Report Maintenance HHE Production and Manufacturing H 5j Reporting Objects Examples Current User gj Setpoint Analysis Hg Water amp Waste Water Duseraling Mode ACTIVE k a J Start Reload State Project i5 Running Open Raport Info Clear Report Guave x Current Statue Waiting Last Generated 3 5 2012 11 20 58 Help Mest Generation 16 1 2012 00 00 00 Quesumd Close A You can select a project to which the Runtime Management Console will be connected B You can reload the project or the reports or shut the project NOTE You can also re
19. list ungn Printing over the network settings Exporting to Excel file Generation of reports based on batch Publishing in Dream Report Web Portal Dynamic Item replacement T Creating advanced reports Defining Applying advanced Page and Report Templates Applying a wide range of dynamic objects for data extraction display LOGGING DATAINTO ANY STANDARD DATABASE SQL Server Oracle INDUSTRIAL a Report generation on schedule Report generation on event generation Min Max Average Current integral Duration SOL query free mathematical calculations etc REAL TIME DATA amp ALARMS OPC DA AE Direct Native Drivers Wizcon PCVUE etc EXISTING HISTORIAN DATABASES OPC HDA ODBC Native Drivers BACnet Wizcon iMistorian PcVUE etc 5 Page J Dream Report System Requirements Minimum System Requirements CPU Duo Core 1 6 GHz y Y RAM 2Gb HDD 350Mb for installation minimum Video adapter No requirements Network adapter No requirements Monitor Resolution 1024x768 Operating systems supported Windows XP Professional Edition web portal requires Service Pack 3 and higher Windows 2003 Server incl R2 web portal requires Service Pack 2 Windows 2008 Server incl R2 any SP and 32 bit and 64 bit Windows Vista web portal requires Service Pack 1 and higher Windows 7 32 bit and 64 bit with and without SP1 Wi
20. load project reports directly from the Dream Report Studio by clicking on the Reload project or Reload reports command buttons C You can access different functionalities directly from the Runtime Management Console D You can generate the selected report there are 3 options for the report generation format PDF Excel and PDF and Excel E You can open the generated report in one of the 3 formats PDF Excel and PDF and Excel F You can open Dynamic Report Generator window for dynamic report generation G You can visualize current status of the reports generation queue i e list of reports which are being generated now in runtime or are waiting in the queue for generation You can generate reports on demand by using Dynamic Report Generator where you can define time period for the report or select manually the list of tags which will be used for specific report generation directly in runtime please see the picture below 2 Page Dream Repo rt Dynamic Ger t 1 Use original time period Define time period Absolie or relative period defirition v Open Panter Absolute or relative period definition P Start of report period Select List of Tags for Replacement Absolute Date Time Dae 7 5 2012 7 40 46 PM HMM SS End of period Absokte Date Time Date 8 8 2012 14046 PM HH H MM SS 28 Page NY Dream Report CHAPTER 3 DREAM REPORT WEB PORTAL Dream Report has its own proprietary
21. mes 4 Note If you want to import data from all data items available at the data source you DON T need to open the item selection window Just check the check box Import all items and Custom Archive Import Tool will import all values from all found items 5 Set Data retrieval mode by schedule or on absolute time 6 Click on the button Add The import definition will be added to the List of archive import definitions 33 Page S Dream Report SETPOINT ANALYSIS Use Setpoint Analysis for smart analysing of thermal and other processes where the process is based on a setpoint stability analysis please see the picture below Zasip 4 au ate ican l i La m D Vah i Lie Toler PE iC Desare papri Hest Cer lt P TI bz ge Ur Eshurrsad History Sak JT Lae Toler are z I a L elect Dats Ina Or Reba of change before pet Rute of char atur ee Lopp k Liri pes Links D s maru a in rare a T Date Ur Pee liora pen gu t Dan Caen C Shark od period i Ered cd pewiced Erch D ana Tampi t wt of changez Ers ol vals haps Batch iste Tar 1 Spacifie vadum 2 Spe eam Proce Mei Crier eat Values Are Wii hin Dei med Bandesdhin Durirsg Seats Perkd Esbs cd Change E Fiot Lest Than Exparbesd Fests of Change E Fior Plone Than Expesctec Earthi Fodure Frons Cakculsi ec ay Perce fe gres e Pate of Chapa Beet ce Saba Fl tgreee ate of Charge After Stablit Jig
22. n To get the most out of Dream Report consult these resources Online Help FAQ Dream Report website Technical Support Team by email support dreamreport net Audience This manual is intended for the first time Dream Report users SolPage Dream Report Chapter 1 Creating a Project in Dream Report As soon as Dream Report has been installed you can start creating a project which you can later develop according to your needs You can use the mechanism of project creation which is described in this chapter to create different projects in Dream Report This is an overview of the major steps you need to go through when you start creating a project in Dream Report CREATING A NEW PROJECT CONFIGURING CONNECTIVITY AND COMMUNICATION DATA ALARMS LOGGING BATCH DEFINITION CONFIGURING A REPORT DESIGNING A REPORT 9 Page NY Dream Report Step 1 Creating a New Project 1 If Dream Report isn t opened click the DR icon on the Desktop Dream Report Studio will be started with the Open Project window When you start the new project please enable the radio button New Project The next time when you need to open the project which has already been set please enable radio button Open Existing Project please see the pic below Open Propet X C Mess Project The Open Project window has an option Run Project Wizard which is located just below the New Project radio
23. n and authentication for access to different project modules Project Parameters configure if needed passing filtering internal project parameters for report generation Data Base Configuration configure databases for data and alarm logging within the entire project Data can be logged either to the Dream Report default database or to any open database using the ODBC interface Web Configuration define the remote station list for the web portal Project Paths configure destination folders where different project files will be written to Log File define a log file to log online errors and information which may be useful in debugging or auditing a project Hotbackup Configuration define the local reporting runtime node as a redundant station coupled with the main station I3lPage Commr caion Configurabion Wizard Select Data Sauce Type Dream Report Localization set the language of the interface i e all dialog boxes and menus configure date time week and display settings for the report objects Step 2 Configuring Connectivity and Communication Now you need to connect to a data source to acquire live data alarms or command button Driver Configuration x 29 Ibarra M onvdenaare i P Aspeniach Aun P sg TEE Modbus TOP HSz32 A500 o ODBC HHA DLE D8 jo DPC A8 SNMP pakina alae Citeci K mj Semen 2g Ewothem i Loia i ET Palit ehea Jala Souce Dercinpli
24. n the Project Settings dialog box which will be opened please see the pic below l11lPage Dream Report Project Author Ocean Dats Systems Project Descnpbon User Authentication Enable user authorization Define Users Internal Project Parameters IPP Data Base Definition Set Paths 3 Click OK and the Dream Report Studio will be opened for your project configuration settings 4 Click General on the Project ribbon icon on the horizontal toolbar in the ream Report Studio see the picture S Home Connectivity Projet Web Elements Tools p i ua e ifs fer f log Hotbackup edd Project Parameters Login with Edit project Version Definition configuration File configuration Pdi Definition different user users control Project Settings User Management Note All the data entered will be applied to the overall project Project configuration files will be saved in a folder which will have the project name you have entered I2 Page Dream Report Project Author Ocean Dats Systems Project Descnpbon User Authentcation Enable user authorization Defne Users Internal Project Parameters IPP Configure Project Parameters Data Base Definition Web configuration w t Set Paths Log He Project Name define general project related information like project name author and description User management define user user group authorizatio
25. ndows 8 Professional and Enterprise 32 bit and 64 bit editions Databases supported MS Access 2000 2003 2007 MS SQL Server 2005 2008 incl R2 MS SQL Server 2005 Express 2008 Express MS SQL Server 2012 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 System Requirements for Manual Data WEB Reports Data Entry Functions are compliant with the following operating systems Windows XP SP3 and higher Windows Vista SP1 and higher Windows 7 32 bit and 64 bit Windows Server 2008 32 bit and 64 bit and Windows Server 2008 R2 Data Entry Functions are compliant with the following database types SQL Server 2005 SQL Server 2005 Express SQL Server 2008 6 Page J J Y Dream Report SQL Server 2008 Express IMS Access 2000 2003 2007 MySQL 4 0 5 0 5 1 Oracle 9 1 10 0 The following Microsoft NET Framework versions are required to be installed on DR server and web client PCs NET Framework 3 5 NET Framework 4 0 For details please refer to the Manual Data Entry section of the Dream Report help documentation Installation 1 in Before Dream Report installation please check if the following components are installed on the target computer a Microsoft NET framework 3 5 or 3 5 SP1 b IIS Internet Information Services please ensure that this component is installed on your PC if you plan to run the Dream
26. or ee PO Fried pena if meee ees access its history To do this please select an appropriate communication driver in the Communication Configuration Wizard dialog box it can be opened either from the Logger Studio or from the Report Designer Studio menu by clicking the Dehred Direer List D ireer Logical H eme BB snaps m UDSL Alm lllocac 425 B nsu c Select the type of the data source from the Data Source tree the first browse level will be the list of the data source vendors displayed as folders Give the logical name to the selected driver Configure the selected driver button Configure will open the driver configuration dialog box Each driver has its own configuration user interface which depends on the specific protocol needs If driver doesn t have any configuration interface that button will be disabled Add the selected configured driver to the list of defined drivers Note When changing the definition of an existing driver please be aware that the name of the existing driver can NOT be changed I4 Page S Dream Report Step 3 Data Alarms Logging optional Dream Report allows connecting to the external data sources and logging data and alarms from the external database into the Dream Report internal history database You can split different data items alarms by groups and define separate logging conditions for each group of data items alarms If any item alarm group has al
27. orts enter manual values in WEB reports and create real interactive web reports 29 Page S Dream Report Deam Report Portal 1 7 2011 Welcome to Ocean Data Systems Reporting Portal Current Level Report Report name Description Generated on New o 326 e ster Tra mean 1 New Dynamic Report Generation you can generate reports or report instances on demand in the Web Portal 2 PDF Excel Report Format Display you can visualize the last reports generated both in PDF and Excel formats 3 WEB Report Format Display you can visualize web pages with reports which have Web option enabled No history of those reports is displayed 4 Virtual Report Instances you can visualize virtual instances of the report if defined in the Reports List tree When you expand this tree the list of instances of that report will be displayed Generated on and History columns will display info for each instance If you need to find all the information about the report generated go to the Detail page of Dream Report Web Portal please see the picture below 30lPage Dream Report Dream Report Portal Powered Ay DOS Tacherokog 10 1 2013 pL English amp j Beport Report Production i Keport Fila Har ma HaepartPreduckinn T 03 1218 458 523 pdf bu 3 15 2012 6 48 57 DIN Reports List 3 acean Report timeazkamp E Sg Batch reports raport nama ie 7 Energy Report examples ie 5
28. ready been created and you want to create a new group you can open the Dream Report Logger Studio right click in the left top for data items or left bottom for alarms part of it and add an item alarm group using the context menu In the context menu you can also select an option to edit or duplicate an existing item alarm group delete the selected item alarm group or add items to the selected group If you need to log data alarms into the Dream Report history please go to the Logger Studio of Dream Report mn Pe l Fame Connectetty Propect Web Elame 18 pe 1 EE oo le D le Lt i Dbatih Add tem add alarmi Configuration definition Configuration group group Connectivity conTiguratson z Legging dats item groupes 3 Data 1 d Gata 2 Configuration X Run Pregect Reload praject Ed Logging aarme groups C amy A Logger Studio is a user interface to configure all data and alarm communication and logging B Data Items is the section of the Logger Studio where you can define data logging conditions C Alarms is the section of the Logger Studio where you can define alarms logging conditions I5 Page S Dream Report E Industrial Report depy DreamReport x p E Home Connect iby Wieb Elements Tals Runtime T ow Ty em group x Drever El ch Dbatch Add fem A 7 Configuration definition Configuration group j
29. reee out of the range torn Facer T3 i Litt of deliren zstpoinir 1 Enter a logical Name to define a setpoint logical name is unique and can t be the same for different setpoints 2 Enter Setpoint Value 3 Enter Bandwidth Bandwidth defines high Upper Tolerance and low Lower Tolerance levels for the stability 4 Select items tags which will be used for this setpoint analysis 5 Click on the button Add and a new setpoint definition will be added to the project Its name value and tolerance will appear in the List of defined setpoints 6 Define the stability period by setting the time period when the values will remain stable 7 Define the criteria for the rate of change measurement before entering the 34 Page Dream Report stability zone 8 Define the criteria for the rate of change measurement after exiting the stability zone 9 Select options which will be used to define automatic process validation TAG DICTIONARY Use this functionality to create tag dictionary for multiple reports You can search change replace tag items in an easy and manageable way please see the picture below Pregect Tag Dsctionarg Select data source snd em X Seach and Replace j B ccc V cqp r Dermo Data Sunc Vihear Hami I Cone EE ODAC Bach Data one ODAC Batch Data Tang 2 Proca Batch Das T angl 14 10 Pracesz Batch Date Tem g 15 10 SCADA Dg i 1B B Data liem Picker x 1 Select Gate en 5
30. reports in the Dream Report Web Portal Hyperlink enables to add a text and turn it into a hyperlink Action Button enables to do a pre defined action from the list of actions available Combo Box enables to select values from the predefined list available Timestamp Picker enables to select a timestamp for association with the entered values 5 You can define time period for the selected objects calculations You can e Define the start and end of time period e Select a periodic interval e g hourly e Use a batch definition for batch process reporting Define time period Absolute or relative pernod definition Absolute or relative period definition Fixed Period Batch based Calculated time DO hh mm ss back poopoo hh mm ss back 25 Page S Dream Report us CHAPTER 2 DREAM REPORT RUNTIME After your project and report s have been configured then in order to generate reports and log data into the Dream Report historian database you need to run your project Any Dream Report project can run by means of a special module Runtime Manager Runtime control service This module can run either as a service launched on the PC start or as an application launched on a user Windows login To control all operations related to the Runtime Manager runtime service and report generation the Runtime Management Console RMC is used Runtime Management Console enables managing the project in Runtime i e reload
31. ta retrieval 4 Click on the button Add to add filter to the Aggregated Data Filters List Customer Feedback Dream Report welcomes your feedback For comments and suggestions related to this and other manuals contact contact dreamreport net 38 Page
32. the left part of the dialog window will automatically update the dialog window with the settings of the selected report Step 6 Version Control This functionality enables to track design version of the reports log and track all changes between versions and roll back to a specific report version number By default it is disabled when the new project is opened It will become enabled if you click on the Version control command button in the User Management section of the Project ribbon icon on the horizontal toolbar in the Dream Report studio please see pic below 20 Page S Dream Report Home Connectivity Project MAFI ments Toots Runtime i Q Hd m Ls 12 te General Data Base Web Set Log Hotbackup Localization Tag Project Parameters Login with Edit praj c Definition configuration Paths File configuration Dictionary Definition different user users Project Settings User Managemen NOTE If the Enable version control option is enabled then any time each version of every report is saved all the history of all the versions of every report will be automatically logged into the project database When the entire project is saved each report will be saved only if there have been any changes in this report Step 7 Designing a Report Now when you have configured the main settings for your report you can start designing it in the Dream Report Designer Studio 1 You can define report and page templates for your report
33. ut this document This document contains 4 chapters which you can use in the order which suits you Chapter 1 Creating a Project in Dream Report takes you step by step through the process of creating a project in the Dream Report Studio giving you the main and important tips on how to define the project and its reports settings data logging and report generation conditions to configure connection to the data sources for data logging to design the project reports layout You can use this chapter as a handy reference as you create your own project in Dream Report Chapter 2 Dream Report Runtime gives an overview of the Dream Report runtime functionality which executes project s running and report s generation Chapter 3 Dream Report Web Portal briefly describes the main functionalities and the characteristic features of the Dream Report proprietary web portal Chapter 4 Dream Report Advanced Tools describes special Dream Report modules which you can use according to your needs for advanced product performance This chapter is aimed at those users who want to explore more of the wide range of functional possibilities which Dream Report may offer Throughout the document you will find sidebars such as Version Control on page 21 that provide useful product related information 3 Page 2 Dream Report About Dream Report Dream Report is professional software for industrial automation for re
34. web portal where all the reports from the entire project are published automatically upon their generation You can browse reports from the currently running project visualize any existing report from the entire project and generate any report on demand in real time directly on the Dream Report Web Portal This web portal uses ASP net web technology and has communication with the Dream Report Runtime Manager using Microsoft NET Framework version 3 5 or higher During its installation Dream Report automatically installs all necessary files to use the web functionality if the web server is installed later you will have to uninstall and re install Dream Report again if you want to use the web functionality This chapter describes Dream Report Web Portal and its functionalities To load the web portal on the local computer you just need to open Internet Browser i e Internet Explorer and type http localhost drweb or http IP address gt or lt URL gt or lt Computer Name gt drweb This will automatically open the welcome page of the Dream Report web portal Dream Report Web Portal e is password protected and enables visualization of all reports from any site e enables users to access authorized reports only e provides direct access both to the lately generated reports and to the archived reports e enables generation of a new report at any time on demand e enables users to easily design web based manual data entry forms rep
35. you can start creating a report reports for your project in the Dream Report Designer Studio Reports visually represent the results of the logged data can be generated according to any time period defined and can be automatically distributed in different ways and formats PDF Excel Printer and Email They can be single page or multiple page You can add or delete pages in your report set parameters and design your report page configure page number date time display You can also add delete or rename a new report by right clicking on the report tree in the Report Designer Studio a Hama Cannertritg Praject Web Elementi Foods Barhme a P yw Fr Ans Puca 8 r BE EE Fa A aw Je v E 4 Ee H JA Paste Obpert 4 Grid Settings Raport Page Insert EFT NUS a X 3J mm UOEM a a Lh nouit a G m amp cu template bempia e 7 Mew Page UA EH nU o gt Fuit Serie Cligeaard Rojo Fanl Test amp bgnmenit Diang Shgnmenl Rutt ard Gad Qu amp k Lg D Logger Suie mam i Finpc Danger Studie Drier List of Feats e Cantigurstipn a oR D Pregect Rept Lect aj T Water B Weer eer y pta Virtuel Report instances Bun Pepprck Apply Page Template Apply Report Templste Reisid prajed Sune Ar Page Template 5 une At Report Template AD Cece Fugit Ta Folder Reload reports Darin Report O Ere Pind be i Lampe rabies IS Page y In this step you can configur
Download Pdf Manuals
Related Search