COOPWARE

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:

  1. 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.

  2. 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.
  3. SQL Reporter Features:
    Status Feature
    Show DB Properties
    Show DB Schema
    Define Custom Reports with Custom Queries
    Export CSV Reports
    ...

SQL Reporter DB Schema

SQL Reporter Report

SQL Reporter Edit Query

SQL Reporter Version 0.9.0.7 (C#, .NET 4)
sqlrepo.exe Any CPU
sqlrepo.chm Help File