Quick Reporting Tool is a simple and user friendly SQL query tool built for SQL developers to create SQL query with or without parameter for the end users to execute and export data efficiently from database to file. The SQL query with parameter(s) will prompt for “user input criteria” when it is executed. Quick Reporting Tool consists of two modules, i.e. Developer Module and End User Module.The Developer Module is for developer to create database connection (using ODBC or OLE DB Provider), as well as to create, edit and save the SQL query into an encrypted query file so that the end users are able to execute it in the End User Module. Users are also allowed to run the query by passing command line parameters to Quick Reporting Tool’s Developer Module to perform scheduling in Windows Task Scheduler
Connect to a database via a ODBC or OLE DB provider, create SQL queries and execute them with just a few clicks using this application
Quick Reporting Tool – Developer Module
Review by Mihaela Teodorovici on August 24, 2015
What’s new in Quick Reporting Tool – Developer Module 1.0.4:
- Added “Insert Parameter” button and “Parameter Assistant” screen. Now users are allowed to create the parameter using GUI. To open “Parameter Assistant” screen, just click on the “Insert Parameter” button.
- Bug fix for “Undo” and “Redo” function.
READ THE FULL CHANGELOG
Quick Reporting Tool is an SQL query builder that aims to be as intuitive as possible, allowing database administrators to create queries and end users to execute them with ease. The Developer Module of Quick Reporting Tool can help its users set up a new database connection and build SQL queries that can be then executed using the End User Module.
Write SQL queries to execute later
Each time Quick Reporting Tool – Developer Module is launched, it prompts the user to select the desired database connection. A new one can be configured in two different ways: either by creating a UDL file and configure it in the Data Link Properties window using am ODBC or OLE DB Provider, or by inputting a connection string into a text file.
Quick Reporting Tool displays all the database tables and their fields in a user-friendly interface, which also comprises an area dedicated to writing the SQL query. Aside from the ‘SELECT’ statement, one can use other SQL statement in a query, such as ‘INSERT’, ‘DELETE’, ‘ALTER’, ‘UPDATE’, ‘TRUNCATE’, and so on.
Execute SQL queries and export them to file
There are 25 parameter types that can be used in SQL queries created with Quick Reporting Tool. The documentation describes them all in detail, providing usage examples to help out users get acquainted with the application. Furthermore, these commands can be used to schedule new queries in the Windows Task Scheduler.
Resulting SQL queries can be executed within the Developer Module of Quick Reporting Tool to see the output, but there is an option to execute them to a delimited text or Excel file that can be then shared with others.
Reliable SQL query builder
Together with the End User Module, Quick Reporting Tool – Developer Module is a powerful SQL query creation and execution tool. It can connect to any database via an ODBC or OLE DB provider and retrieve database entries that match the criteria in the SQL query.
Results are displayed in an organized manner, inside a table, and users can export the data to a file for later reference and sharing with end users. A big plus is that the query file is automatically encrypted, so as to prevent unauthorized modifications.
Quick Reporting Tool – End User Module Description
Quick Reporting Tool – End User Module is for user to execute the SQL query created from the Developer Module. In order to prevent the actual SQL query created by the SQL developer from being modified, the query file has been encrypted and the End User Module has disallowed user to create or edit any SQL query.Whats new in this version:
What is SQL Server Reporting Services (SSRS)?
APPLIES TO: ✔️ SQL Server 2016 Reporting Services and later ❌ Power BI Report Server
Looking for Power BI Report Server? See What is Power BI Report Server?.
SQL Server Reporting Services (SSRS) provides a set of on-premises tools and services that create, deploy, and manage mobile and paginated reports.
Create, deploy, and manage mobile and paginated reports
The SSRS solution flexibly delivers the right information to the right users. Users can consume the reports via a web browser, on their mobile device, or via email.
SQL Server Reporting Services offers an updated suite of products:
- “Traditional” paginated reports brought up to date, so you can create modern-looking reports, with updated tools and new features for creating them.
- New mobile reports with a responsive layout that adapts to different devices and the different ways you hold them.
- A modern web portal you can view in any modern browser. In the new portal, you can organize and display mobile and paginated Reporting Services reports and KPIs. You can also store Excel workbooks on the portal.
The embedded analytics experience you need to make things personal
Never provide a generic customer experience again. Simple, yet robust, Logi’s fully embedded analytics empower your application to drive growth that’s great for business, and personalized for every user.
Quickly and Easily Create Rich, Dynamic PDF Reports
Now it’s easier than ever to make and distribute dynamic, professional reports in Ignition. The Ignition Reporting Module is a standalone reporting solution that simplifies and enhances the reporting process from beginning to end. Generate reports from existing files or create them from scratch. Pull data from a variety of sources, and design reports with a simple-to-use interface. Add charts, graphs, tables, crosstabs, shapes, and other components for visual impact. Save your reports in PDF, HTML, CSV, and RTF file formats, and set up automatic scheduling and delivery.
Use all of these powerful capabilities to quickly create many common types of reports such as production management, efficiency monitoring, downtime tracking, SPC, QA, OEE management, and historical data analysis.
Select Data from Many Sources
The Reporting Module makes it easy to define the data behind your reports. Specify any number of report parameters and data sources in your reports. Access information from any SQL database. Also, you can easily query data from Ignition’s tag historian and event data from the alarm journal.
Design Reports with an Easy-to-Use Interface
Design your reports easily inside Ignition’s Designer application. The interface is far more user-friendly than those of other reporting software, because it enables you to design reports with the same intuitive feel and rapid application development tools that you get when designing applications in Ignition. This allows you to design your reports using the drag-and-drop method.
Schedule Reports to Run Automatically
The Reporting Module allows you to schedule reports within the Ignition Gateway. You can schedule a report to run on a regular basis; for example, on every Monday at 5:00 p.m. Then, your report will run as scheduled whether or not any Ignition clients are open.
You also have the option to set up triggered execution, which means that reports run on-demand when triggered by an event such as a tag change, a shift change, the finish of a production run, etc.
Print, Send, or Save Automatically
Scheduled reports can be automatically delivered in many ways: print, email, save to a file server, upload to an FTP server, or use scripting to customize the method of delivery. Have your reports distributed in the way you want, every time, automatically.
Powerful Query Tools
The Reporting Module has a powerful drag-and-drop query interface that allows you to build complex SQL queries easily. The new query structure allows you to create complex nesting which can correlate relational data and process-historian data in a seamless fashion.
Some additional features of the Reporting Module include a powerful report pagination engine, backwards-compatibility for reports created in previous Ignition versions, a new preview mode, and more.
Powered by Ignition
Because the Reporting Module is built on the power of Ignition, it shares the same advantages, such as cross-platform compatibility, unlimited free clients, robust out-of-the-box SQL database support, and fast installation. Leveraging the full power of Ignition, it is a reporting tool unlike any other in the SCADA software market.