- Agata Report
Agata Report is a cross-platform
database reporting tool created by Pablo Dall'Oglio. It contains graph generation and a query tool that allows you to get data fromPostgreSQL ,MySQL ,SQLite , Oracle, DB2,MS-SQL ,Informix ,InterBase ,Sybase , orFrontbase and export that data as plain text,HTML ,XML , PDF, orspreadsheet (CSV) formats through its graphical interface. You can also define levels, subtotals, and a grand total for the report, merge the data into a document, generate address labels, or even generate a completeER-diagram from your database.Features
* Works the same way for
Linux andMicrosoft Windows .
* Export the report to many formats, like plain text, HTML, XML, CSV (spreadsheets like StarCalc or Excel), PDF and OpenOffice Writer.
* Connect to most popular databases like PostgreSQL, MySQL, SQLite, Oracle, DB2, MS-SQL, Informix, InterBase, Sybase and FrontBase.
* Generate the complete ER-diagram from your database inDia format.
* Allows to cross report's data with another database. (PostgreSQL x Oracle), for instance.
* Agata has a Function Repository. You may write anyPHP function and apply it on thereport .
* Through AgataAPI, you may execute the reports through your PHP scripts and make the report available on the Web.
* Through AgataCLI, you may execute the reports through command line (Linux shell orMS-DOS prompt).
* Allows you to define nicknames (aliases) for tables and fields (data description).
* Allows you to establish links among all tables and use this when making the report or generating the diagram.
* Allows you to define report levels and apply functions to each level (sum, max, min, count, avg) and the grand total.
* Trough Graph tool, you may generate line and bars graphs from your report.
* Trough Merge tool, you can merge your free-handed document with the data from areport and create letters dynamically, for example.
* Support for run-time parameters. Agata asks the user for values when the report runs.
* Interface support for English, Portuguese, Spanish, Italian, French, German and Swedish.
* License is CC-GNU-GPLExternal links
* [http://www.agata.org.br/ Agata Report Official Site]
Wikimedia Foundation. 2010.