Art SQL to Anything Art SQL to Anything - tool to generate Excel, Word, PDF, CSV files from SQL buy [$25]  

  • Supports Joomla! 1.5, 1.6, 1.7, 2.5, 3.x
  • Can generate PDF, Excel/XLS, Word/DOC, CSV files from SQL queries
  • Can retrieve data from Joomla! database or other databases
  • The following database types are supported: fbsql, gladius, maxdb, msql, mssql, mssqlpro, mysql, mysqli, mysqlt, odbc, postgres, postgres64, postgres7, postgres8, sqlite, sqlitepro, sybase, sybase_ace. To work with some databasee appropriate php extension may need to be installed and enabled
  • Simple and complex SQL queries are supported
  • When downloading created file associated SQL query is run and downloaded file contains actual data
  • Screenshots are below

1. List of queries

2. Create query - use Joomla! database

3. Create query - use different database

4. Create query - list of possible database types

5. New file - PDF

6. New file - XLS

7. New file - DOC

8. New file - CSV

9. New file - use new query

10. Generated PDF file

11. generated XLS file

12. Generated DOC file

13. Generated CSV file

14. Generated PDF file - column width changes according to number of fields