Contens
|
SQL Reporter (Freeware)
SQL Reporter is a simple Reporting Tool for SQL Databases
(currently tested with MySQL and SQL Server).
Before you start choose a Connect String for each Database:
- For MySQL Databases use
in Toolbar to define an ODBC User DSN:
- As Driver use MySQL ODBC 8.0 ANSI Driver
- Configure an User with read rights on your Database and a Password
- Specify the Connect String: DSN= in the SQL Reporter Settings.
You also may change the Root Directory:
Each Database uses a folder Root Directory\Database Name .
- For SQL Server you have 3 Options:
- ADO:
Server=tcp:sqlsrv.org.net; Database=YourDB; Integrated Security=true
- OLE:
Provider=sqloledb; Server=sqlsrv.org.net; Database=YourDB; Integrated Security=SSPI
- ODBC: Use
in Toolbar to define an ODBC User DSN:
- Enter a name for the DSN, a description and the name of your SQL Server.
- Use Windows Authentication and set the Standard DB to the Name of your SQL Database.
- Specify the Connect String: DSN= in the SQL Reporter Settings.
- SQL Reporter Features:
Status |
Feature |
 |
Show DB Properties |
 |
Show DB Schema |
 |
Define Custom Reports with Custom Queries |
 |
Export CSV Reports |
 |
... |
SQL Reporter Version 0.9.0.5 (C#, .NET 4)
sqlrepo.exe Any CPU
sqlrepo.chm Help File
|