SCADA Tutorial #7 | Reporting, SQL Queries & Automatic Report Generation
đź“Ś In this episode of the Wise SCADA training series, we take a detailed look at the Reporting module, one of the most critical components of industrial automation projects.
In this lesson, you will learn step by step how to transform collected system data into meaningful, visual, and professional reports, manage databases, customize SQL queries, and generate reports automatically.
We cover how to modify default SQL queries, apply dynamic date range filtering during Runtime, and display report results using tables and charts. You will also learn how to create corporate-style reports by configuring headers, footers, company logos, and exporting reports in PDF and Excel formats.
In the final part of the video, we implement a fully automated reporting solution using Triggers, allowing reports to be generated at scheduled times (for example, every day at 00:00) without operator intervention.
🔊 Multi-Language Audio Available! This Wise SCADA training video includes multiple audio tracks. Click the Settings (⚙️) icon and select “Audio Track” to choose your preferred language.
đź“Ś What You Will Learn in This Lesson
âś… Database Selection – Choosing between SQLite, MySQL, or SQL Server for your project
âś… SQL Query Management – Custom data queries using SELECT, WHERE, and AS clauses
âś… Dynamic Filtering – Date-based reporting using Start Time and End Time tags
âś… Data Visualization – Displaying report data with Table and Chart objects
âś… Exporting Reports – Creating professional PDF and Excel reports with logos and headers
âś… Automation – Periodic automatic report generation using Time-Based Triggers
- 00:00 – Introduction & Overview of the Reporting Module
- 00:32 – Database Structures: SQLite vs. MySQL / SQL Server
- 01:35 – Creating and Testing SQL Queries (Compile / Execute)
- 02:54 – Date Range Filtering Using Tags (WHERE Clause)
- 05:15 – Column Selection and Renaming (AS Clause)
- 05:51 – Displaying Reports with Charts and Tables
- 06:19 – PDF & Excel Export Settings (Header, Footer, Logo)
- 07:54 – Report File Storage Location & Folder Structure
- 08:15 – Status Bits: Done, Fault, Last Recorded File
- 10:13 – Automatic Reporting with Triggers (Scheduler Setup)