Wise SCADA Tutorial #7 | Reporting, SQL Queries & Automatic Report Generation

🔊 Multi-Language Audio Available
This Wise SCADA training video includes multiple audio tracks.
You can select your preferred language by clicking the Settings (⚙️) icon and choosing “Audio Track”.

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.

📌 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

🔗 Useful Links
Download Wise SCADA:
https://www.fultek.com.tr/en/scada-software/

⏱️ Chapters
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)

👍 If you found this video helpful, don’t forget to like, subscribe, and enable notifications for more Wise SCADA training videos.

#WiseSCADA #SCADATraining #Reporting #SQL #Automation
#IndustrialAutomation #Database #SQLite #Triggers

Видео Wise SCADA Tutorial #7 | Reporting, SQL Queries & Automatic Report Generation канала Wise SCADA