Free report designer sql software for linux

iReport project is a powerful, intuitive and easy to use visual report builder/designer for JasperReports written in 100% pure java.
This tool allows users to visually edit complex reports with charts, images, subreports,.... iReport is integrated with JFreeChart, one of the most diffused OpenSource chart library for java.
The data to print can be retrieved through several ways including multiple JDBC connections, TableModels, JavaBeans, XML, etc...
Enhancements:
- Full support for JasperReports 1.3.4.
- A new XML field mapping tool.
- A new document structure outline.
- Improved refactoring capabilities.
- An improved report query dialog.
- An improved UI with sortable tables.
- Several bugfixes.

The IceWM Control Panel (IceWMCP) IcePref2 Theme Designer tool allows you to easily create and modify themes for IceWM.
IceWM Control Panel (IceWMCP) is the first full-featured, Gtk-based control panel for IceWM. It is meant to run in IceWM, but can be used in ANY window manager as a general-purpose control panel.
IceWMCP is multi-lingual. Currently, the following languages are supported: English, Spanish, Russian, Traditional Chinese, French (partial), and Finnish (IceWMCP-IceMe only).
Developers: If you would like to use IceWMCP as the foundation for a new control panel (for a new window manager, etc.), see the developers release of IceWMCP. IceWMCP was inspired by the Qt-based application called IceCC, but includes many more tools, a more familiar Windoze Control Panel-like interface, and uses the MUCH faster Gtk user interface (Who runs a fast Window Manager like IceWM, to launch SLOW-running, memory-intensive Qt/KDE-based applications?? I sure dont).
Lets face it: IceWM and fast Gtk interfaces work well together. In addition, because IceWM Control Panel is written with a TRUE open source widget set, Gtk+, you dont have to worry about the licensing problems associated with proprietary QT-based applications. IceWM Control Panel is TRUE open source, through and through.
Version restrictions:
- Access to a Bash shell (very important)
- Python (2.2 or better), PyGtk-2 (1.9.9/2.0.0 or better)
- Gtk+ 2.0.6 or better - neither Gnome nor PyGnome is required
- (IceWMCP versions 2.5 and earlier require Gtk+1 and PyGtk-1 0.6.9)
- Your version of PyGtk should have the Gdk-Pixbuf modules on your system
- Please run ALL IceWMCP programs from a BASH shell: Using other shells such as ksh, pdksh, csh, tcsh, etc. is likely to cause problems.
- If your IceWMCP programs have trouble launching other applications, it is most likely because you are using something other than a Bash (/bin/bash) shell.
- Run the programs from Bash...period!

SRG is a Squid Report Generator designed for the needs of CRCnet. None of the existing report generators could provide the exact solution that we required and we decided to start from scratch rather than trying to modify an existing progamme.
SRG is designed to be fast and easy to integrate in to other authentication systems (such as those that are driving Squid itself).
Main features:
- PHP Output with built in authentication hooks
- Fast Processing
- Reporting right down the the location vistied
Enhancements:
- Fixed assertion failure when output directory contains a subdirectory with an invalid name.
- Fixed compilation problems on sparc64. Endianess problems.
- Fixed bug with localtime using a static buffer (or similar) which caused the Period to be misreported as firstdate - firstdate.
- Marked -A, -c, -D, -e, -L, -p, -P and -T as deprecated. See FAQ for details.
- Added option (-r) to allow sorting output reports by any column via javascript
- Added meta tags to prevent indexing of reports by robots
- Minor stylesheet updates
- SRG now defaults to generating location reports
- SRG now defaults to showing the requesting host in location reports
- -H is now used only to specify whether DNS lookups should be performed
- Fix some minor output formatting errors reported by Guiliano Cioffi
- Added some example scripts for generating SRG reports
- Added basic debian package

Progress Report Manager project is a system for entering and sending school progress reports for teachers and parents.
The Progress Report Manager was built to alleviate problems experienced with traditional school progress reports.
Administrators create progress reports that are automatically sent via email.
Every week, teachers receive a message in their inbox reminding them that a new progress report has been created.
The teacher completes the progress reports online using a Web browser.
At the end of the week, the administrators click a button which sends email messages to every parent whose child received a report.
The parents can look at their students progress online and reply to teacher comments using response features.
Enhancements:
- inactivate students fixed
- help files fixed / modified / written
- report views fixed
- log files can be flushed
- semesters fixed

DBDesigner is a program to create any visual design of MySQL databases.

f you need to build complex SQL databases you will find DbDesigner quite a useful tool. It allows you to construct your DB in an intuitive and easy to use environment, where you have a visual representation of the tables and relations contained in your project.

You can quickly see the fields in a table or how each table relates to the others. After you are finished, DbDesigner can export the schema of the database into an .sql script, or directly connect to a database backend and build it there. It can also import already existing databases from .sql scripts or db backends.

Of course, it can save your project into its native format (XML) so all information is kept (for example you cant save the positions of the tables in the workspace into an .sql script). Due to its plugin architecture, DbDesigner is easily extensible to work with many database servers. By default it comes with 2 plugins: one for PostgreSQL and the other for MySQL.

On the other hand, if you are building complex databases you might have already seen products like this one. So you may ask why another visual database designer? Thats easy: because I havent seen one for the Linux platform so far. Somebody had to "scratch the itch" sometime...

Kexi Report Part is a reporting component for Kexi 1.6 based on OpenRPT 1.2.
Main features:
- A report viewer for Kexi
- An external report designer (KexiReportWriter) based on the OpenRPT writer program
Known Working Features
- Page Header
- Page Footer
- Report Header
- Report Footer
- Detail section
- Labels
- Lines
- Fields
- Page Browser
How To Create Report
1. Install the component following the instructions in INSTALL
2. Run KexiReportWriter to start designing a report
3. Select Database->Connect to DB
4. Browse to an existing Kexi Database and open it
5. Create a new report (File->New)
6. Assign a data source to the report (Document->Properties)
7. Create the report using labels/fields/lines
8. Assign columns to the field objects (Double click for properties)
9. Save the report. (Database->Save to DB)
10. Load the database in Kexi and double click the report to view it
Enhancements:
- Removed requirement to have kexi source available to install the plugin.Done this by including the needed kexi headers in the package. Only downside is that kexi 1.1.3 (from koffice 1.6.3) is required.