Newbies What Next ? News Forums Calendar


News Sections
General News (3987/0)
Reviews (637/0)
Press Releases (465/0)
Distributions (197/0)
Software (915/0)
Hardware (537/0)
Security (192/0)
Tutorials (356/0)
Off Topic (181/0)

User Functions


Don't have an account yet? Sign up as a New User

There are no upcoming events

Agata Report

Agata Report

Agata Report is a cross-platform database reporting tool.

This software application provides graph generation and a query tool that allows users to obtain 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.

 Agata Report 7.7

Free to download



Pablo Dall'Oglio


System Requirements


Selected Reviews:

Features include:

  • Export the report to many formats, like plain text, HTML, XML, CSV (spreadsheets like StarCalc or Excel), PDF and OpenOffice Writer
  • Generate the complete ER-diagram from your database in Dia format
  • Allows to cross report's data with another database. (PostgreSQL, Oracle), for instance
  • Agata has a Function Repository. You may write any PHP function and apply it on the report
  • Through AgataAPI, execute reports through PHP scripts and make the report available on the Web
  • Through AgataCLI, execute the reports through the Linux shell
  • Define nicknames (aliases) for tables and fields (data description)
  • Establish links among all tables and use this when making the report or generating the diagram
  • Define report levels and apply functions to each level (sum, max, min, count, avg) and the grand total
  • Through Graph tool, generate line and bars graphs from your report
  • Through Merge tool, merge a free-handed document with the data from a report and create letters dynamically, for example.
  • Support for run-time parameters. Agata asks the user for values when the report runs
  • Standard Reports
  • Hierarquical groups summary, subtotals and Grand total
  • Headers and Footers
  • Nick Names for Tables and Fields
  • Mailing Labels
  • Form letters with subreport
  • Bar Code Generation
  • Cross Tab Reports
  • Open Office Report builder
  • Field Masks
  • Sub Reports
  • Data Explorer
  • Report Explorer
  • Preview Window
  • Run-time Parameters (client and web version)
  • Conditional Formatting
  • Custom Functions (PHP scripts repository)
  • Agata Report API
  • Command Line Report Generation
  • Linked Tables suggestion
  • Groups of Tables
  • Query Templates
  • Layout Templates
  • Field mapping between databases
  • Generation of linked ER-Diagram from Database
  • Lines and Columns graph support
  • External Viewer configuration
  • Fonts, Sizes and Colors configuration dialog
  • Client Interface
  • Web Interface to generate reports
  • Interface support for English, Portuguese, Spanish, Italian, French, German and Swedish

Return to Business Intelligence Software Home Page

Bookmark and Share

Last Updated Friday, July 03 2015 @ 05:03 AM EDT

We have written a range of guides highlighting excellent free books for popular programming languages. Check out the following guides: C, C++, C#, Java, JavaScript, CoffeeScript, HTML, Python, Ruby, Perl, Haskell, PHP, Lisp, R, Prolog, Scala, Scheme, Forth, SQL, Node.js (new), Fortran (new), Erlang (new), Pascal (new), and Ada (new).

Group Tests
100 Essential Apps
All Group Tests

Top Free Software
5 Office Suites
3 Lean Desktops
7 Document Processors
4 Distraction Free Tools
9 Project Management
4 Business Solutions
9 Groupware Apps
14 File Managers
10 Databases
21 Backup Tools
21 Productivity Tools
5 Note Taking Apps
9 Terminal Emulators
21 Financial Tools
5 Bitcoin Clients
21 Text Editors
21 Video Emulators
21 Home Emulators
42 Graphics Apps
6 CAD Apps
42 Scientific Apps
10 Web Browsers
42 Email Apps
12 Instant Messaging
10 IRC Clients
7 Twitter Clients
12 News Aggregators
11 VoIP Apps
42 Best Games
9 Steam Games
42 Audio Apps
5 Music Streaming
42 Video Apps
5 YouTube Tools
80 Security Apps
9 System Monitoring
8 Geometry Apps
Free Console Apps
14 Multimedia
4 Audio Grabbers
9 Internet Apps
3 HTTP Clients
5 File Managers
8 Compilers
9 IDEs
9 Debuggers
7 Revision Control Apps
6 Doc Generators
Free Web Software
21 Web CMS
14 Wiki Engines
8 Blog Apps
6 eCommerce Apps
5 Human Resource Apps
10 ERP
10 CRM
6 Data Warehouse Apps
8 Business Intelligence
6 Point-of-Sale

Other Articles
Migrating from Windows
Back up your data
20 Free Linux Books
24 Beginner Books
12 Shell Scripting Books

Older Stories
Saturday 05/16
  • 9 First Steps with Ubuntu 15.04 (0)
  • Excellent Console Log File Analyzers (0)

  • Monday 05/04
  • 100 Essential Free Apps (0)

  • Saturday 04/25
  • What are good command line HTTP clients? (0)

  • Sunday 04/12
  • First Peek at XBian on the Raspberry Pi 2 (0)

  • Saturday 04/04
  • First Look at OSMC RC on the Raspberry Pi 2 (0)

  • Sunday 03/29
  • First Steps with OpenELEC on the Raspberry Pi 2 (0)
  • Ubuntu MATE 15.04 for Raspberry Pi 2 (0)

  • Monday 03/16
  • MIPS Creator CI20 v Raspberry Pi 2 (0)
  • Raspberry Pi 2: Raspbian (ARMv6) v Linaro (ARMv7) (0)

  • Vote

    What Linux distribution do you run on your main computer?

    995 votes | 3 comments

    Built with GeekLog and phpBB
    Comments to the webmaster are welcome
    Copyright 2009 - All rights reserved