SQL-based Reports
- Sebastian May
- Abir Haque
- Thomas Wais
This pages describes SQL based reports in pathfinder.
Select SQL based report from the manage reports dialog window add button.
You can create SQL based rules to generate your reports.
In the SQL based report database selection dialog window, you can define your connection for database queries. The dialog window provides the following fields to fill out:
Use current connection: Check this box to use the current database connection for creating your report.
Hostname/ IP: Assign the hostname or IP address of the database.
Login: Define the log in username.
Password: Define the log in password.
Database: Define the name of the database.
Port: Define the port number.
Server-Type: Define the server type. You can also test the connection to the database here.
Enable encryption: Check to enable encrypted connection.
Click on next to continue.
In this dialog window, you can create the SQL based rules for your report.
You can select your fields here (1).
You rules are displayed here (2).
Click on next to continue.
In this dialog window you will see an overview of your report.
You can drag ang drop column headers up to the “Drag a column header here to group by that column” to view in groups.
Click on next to continue.
In this dialog window you can save your report.
You can cancel all progress so far, save the report or save the report with a specific name.
You can also set the privacy of the report and write short description about the report.
Click on Finish to view your report.