- Knowledge Base
- Software
- Visualization / SCADA
How to Aquire Your Data Using SQL Statements in Dream Report
Dream Report is a tool for visualizing data from multiple sources.
This tutorial showcases how to integrate Dream Report with SQL Server to visualize data. It demonstrates two methods for pulling data: one using a permanent SQL statement within Dream Report and another by typing SQL statements directly. The video guides viewers through creating a DSN for database connection, setting up SQL queries, and generating reports. It also highlights the importance of sorting within SQL statements and the impact on licensing when using the SQL option in Dream Report.