Agata Report is a cross-platform database reporting tool with graph generation and a query tool that allows you to get data from PostgreSQL, MySQL, Oracle, DB2, MS-SQL, Informix, InterBase, Sybase, or Frontbase and export that data as PostScript, plain text, HTML, XML, PDF, 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 and tools:*) Works the same way for Linux and Windows;
*) Export the report to many formats, like PostScript, pain text, HTML, XML, CSV (spreadsheets like StarCalc or Excel), PDF and OpenOffice Writer;
*) Connect to most popular databases like PostgreSQL, MySQL, 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 Databse. (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 scripts 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 Merte 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, Portuguese, Spanish, Italian, French, German and Swedish;
*) Suport all Gtk themes from gtk.themes.org;