Agata Report

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 from PostgreSQL, MySQL, SQLite, Oracle, DB2, MS-SQL, Informix, InterBase, Sybase, or Frontbase and export that data as 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

* 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 in Dia format.
* Allows to cross report's data with another database. (PostgreSQL x Oracle), for instance.
* Agata has a 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 the report available on the 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 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-GPL

External links

* [http://www.agata.org.br/ Agata Report Official Site]


Wikimedia Foundation. 2010.

Игры ⚽ Нужно сделать НИР?

Look at other dictionaries:

  • Agata — NOTOC Agata can refer to:A female name, cognate of Agatha . Usage: Italian, Spanish, Swedish, Polish, Czech, Slovene and Russian.Nicknames: Ag, Aggy, AggiePersonsAgata as first name* Saint Agatha of Sicily, a Christian saint sometime spelled as… …   Wikipedia

  • List of reporting software — The following is a list of notable reporting software.Open source software* Agata Report * Eclipse BIRT Project * JasperReports * Pentaho * GNU Enterprise (reporting sub package)Commercial software* Actuate * Alchemex * Cognos BI * Crystal… …   Wikipedia

  • PHP-GTK — Desarrollador Andrei Zmievski gtk.php.net Información general Última versión estable 2.0.1 16 de mayo de 2008 …   Wikipedia Español

  • OasisERP — Oasis ERP Desarrollador Grupo Desertic [1] Información general …   Wikipedia Español

  • Lamborghini — Création 1951 Dates clés 1998 : reprise par Audi Fondateurs …   Wikipédia en Français

  • Giuseppe Verdi — « Verdi » redirige ici. Pour les autres significations, voir Verdi (homonymie). Giuseppe Verdi …   Wikipédia en Français

  • Giuseppe Fortunino Francesco Verdi — Giuseppe Verdi Pour les articles homonymes, voir Verdi (homonymie). Giuseppe Verdi …   Wikipédia en Français

  • Verdi — Giuseppe Verdi Pour les articles homonymes, voir Verdi (homonymie). Giuseppe Verdi …   Wikipédia en Français

  • literature — /lit euhr euh cheuhr, choor , li treuh /, n. 1. writings in which expression and form, in connection with ideas of permanent and universal interest, are characteristic or essential features, as poetry, novels, history, biography, and essays. 2.… …   Universalium

  • List of Honorverse characters — This is intended to be a comprehensive list of the names of even minor fictional character in the Honorverse, a series of military science fiction novels written by David Weber. Characters are sorted by their last name. Some are sorted by first… …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”