Agata Report is a cross-platform Database reporting tool created by Pablo Dall Oglio at Solis, with graph generation and a query tool that allows you to get data from PostgreSQL, MySQL, SQLite, Oracle, DB2, MS-SQL, Informix, InterBase, Sybase, or Frontbase and export that data as plain text, HTML, XML, Portable Document Format, or spreadsheet (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 complete ER-diagram from your database.
=Features=
Works the same way for Linux and Microsoft 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; (Dia format)
Allows to cross report s data with another Database. (PostgreSQL x Oracle), for instance;
Agata has an Function Repository. You may write any PHP function and apply it on the report;
Through AgataAPI, you may execute the reports through your PHP script (computer programming)s and make report available on Web;
Through AgataCLI, you may execute the reports through command line (Linux shell or MS-DOS prompt);
Allows you to define nicknames (aliases) for tables and fields (data description);
Allows you to stablish 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 report and create letters dynamically, for example.
Suport for run-time parameters. Agata asks user for the values when the report runs;
Interface support for English language, Portuguese language, Spanish language, Italian language, French language, German language and Swedish language;
=References=
[http://www.agata.org.br/ Agata Report Official Site]