Transcript Document
Introducing Dream Report Win Worrall Applications and Development Engineer Reporting for Automation • Common Problems – Costly – Resource intensive – Requires IT, programming skills • Challenges – Accessing real-time plant floor information – Accessing various archives – Connecting to different data sources Dream Report is the solution! What is Dream Report? • Simplest solution on the market • Automatically generates and distributes .pdf and .xls reports • Designed for both Continuous and Batch processes • Aggregates data from real time data sources and existing historical sources • Complements existing SCADA and MES applications Product Architecture Automatically Publish and Distribute Web Portal File Server eMail Printers Mobile Provide Reports Generate and execute Manually: Automatically: Generate Reports On Schedule On Event Select Report Change period or select batch Generate new report Provide Data Design and configure Design Reports • Design reports in easy environment • Use Page Templates Configure Data Aggregation • Use Report Templates Provide Data Connect to Data Sources Data Logger Dream Report logger can archive real time data into any open database • SQL Server • MySQL • Oracle • Access • … Provide Data Real-Time Data and Alarms Access existing 3-d party archives REAL TIME data and alarms K HISTORIAN access - OPC DA-AE • OPC HDA - Native Drivers • ODBC & OLE • CSV files • Native drivers for proprietary archives HMIs, PLCs, DCS, SCADA, … Define and execute periodically any type of calculations: Min, Max, Average, Current, Integral, Duration, Counter, SQL commands, free Mathematical Calculation… A F Works With? • Supports direct connection to existing OPC data sources – OPC DA, OPC HDA, OPC A&E • Can be connected to one or multiple ODBC databases – SQL Server, Oracle, MS Access, etc • Built-in custom drivers for connecting to a variety of historians – Ex. iFix/Proficy, Emerson, Pi, etc. International Integration Made Easy • Web Portal – Ideal solution for distributing and sharing reports over the Internet/intranet – Password protected to display only authorized reports – Easy access to any archived reports – Generate reports on demand • Multi-language user interface support – English, French, German, Italian, Russian, Japanese and more Dream Report for Small Projects • Connect directly to PLCs to collect and archive data • Retrieve values and alarms and display data in charts, tables, and other graphical representation • Automatically retrieve batch information and generate batch reports • Web-based archiving and reporting solution at a low cost Operator Operator Supervisors Dream Report for Complex Projects Operator Recorders Quality Assurance Production Database HMI, SCADA Stations Controllers Historian Process Engineering • Retrieve data from different vendors • Retrieve data from plant database or other 3rd party historians • Run complex consolidated reports • Automatic publishing and distribution of reports inside organization (email, file servers, etc) Why Use Dream Report? • Speed up report development time by 15-20 times • Quickly and easily bring data into valuable, professional looking reports • Requires no IT or programming skills • Make reports easily and securely available to any authorized person through built-in Web Portal • Use in virtually any industry • Already adopted by market leaders Live Demo • Live Demo – Connect to an OPC Data Source – Log Data to a Database – Create Reports using Real-Time and Historical Data – Generate Reports on a Schedule and on Event – View the Reports from a Web Browser – Generate Dynamic Reports from the Web What Tools are Needed? • For all usage scenarios – Tag license required – Web Portal licensing optional Part Number License Count Price 41295101-50T 50 Tags US$1550 41295101-250T 250 Tags US$3300 41295301-2W 2 Web Clients US$1050 41295305-5W 5 Web Clients US$2300 • Support Contracts Available for 15 % of list price • Free Demo Available – Limits to 25 tags – Development will run for unlimited time, Runtime for 30 minutes at a time www.softwaretoolbox.com/DreamReport Contact Information & Other Learning Opportunities • Questions later? – Win Worrall • [email protected] – Software Toolbox Tech Support • [email protected] • 888-665-3678 or +1 704-849-2773 • Product Website – http://www.softwaretoolbox.com/dreamreport • Other learning opportunities – Recording of this webinar – Visit softwaretoolbox.webex.com