Posts Tagged ‘MySQL’

MySQL Reporting Tool

February 13, 2013 Leave a comment

There has always been a need for a good MySQL Reporting tool.   Sunset Reports offers several methods of connecting to MySQL databases that makes it a good choice for creating reports using MySQL databases.

Using the built-in Query builder you can connect directly to a MySQL database as shown in the next figure.

The Query Builder also supports SQL Dialects for the different versions of MySQL.

But of course, you can simply use the ODBC connection if you choose.

Stored Procedures

January 24, 2013 Leave a comment

Sunset Reports provides many options for connecting to data.   This includes:

  1. Direct Connection to Microsoft Access Tables and Queries
  2. Direct Connection to DSN defined ODBC Connections
  3. Direct Connection to Microsoft SQL Server
  4. Direct Connection to Oracle
  5. Direct Connection to MySQL
  6. and others….

There are also a many options using OLD EB and ODBC connection strings as well as Excel, Outlook, XML, and CSV files.

In general connecting to a table, query, or view is straightforward.   But you can also connect to a stored procedure by defining the SQL directly.  And you can pass parameters to those stored procedures as well.

In the following figure, you can see a a stored procedure defined in the SQL block.  This can be edited directly on this form.

1-24-2013 10-10-49 AM

As long as you have a valid ODBC, PDC, SDC, or QB Connection, you should be all set to retrieve data from stored procedures.   This implementation is similar in functionality to Microsoft Access Pass-Thru Queries.

Data Source Types

April 1, 2012 Leave a comment

There are 9 different data source types and even more when you construct a connection string using OLEDB or ODBC.