Basic

SQL Report is an open source web-based reporting system that integrates with your Java/J2EE application to produce compelling reports.

• Easy to deploy, no TagLibs, only one servlet. Even you have choice to use pool JSP to access reports without configuring any sevlet.
• Pure web-based user interface. All functions, including viewing reports and administrative, can be done in IE and FF. No extra applications to be needed.
• Having fun with built-in functions. You can create a complex report with a single SQL and set redering from a web-based GUI.

News

• We are so sorry that the most important vesion of SQL Report is under developing and there is no release of this project. You can contact me via following your interest.

V4.1 Port to GoogleCode (Under developping)

• Port from local project to Google code.
• Removing all personal and commerical mark and information.
• Fixing all known bugs.
• Implementing language pack supporting to support English and Chinese version.
• Renewing documentations into English.
• Updating demo movies for English Version.
• Refacting the source code.
• Decoupling with XML parser.

V4.2 Chart Enhance

• Extracting implementation of chart supporting.

V4.3 Data Source Enhance

V4.4 Cache Data

• Cache report data at the server side.
• User can choose database or file system to save the cached data.
• User can specify the cache strategy.
• The management of cache data

V4.5 GUI and Renders Enhance

• Supporting tree-like columns Dataset.
• Supporting tree-like parameter selector.
• Supporting grouping( Just like Outlook).
• Supporting external render.
• Supporting external parameter collector.
• Supporting external parameter selector.

System Requirement

Client Side

1. Microsoft Internet Explorer 6 and above / FireFox 2 and above.

Server Side

1. Microsoft Windows 2000/XP/2003/Vista or NIX
2. JDK 1.5 and above
3. Tomcat5 and above / WebSphere5 and above / JBOSS4 and above
4. 200M Free hard space (it depends how many cached data is used in your optionion).

Third party libraries used in source code

1. Apache commons-beanutils.jar CORE
2. Apache commons-dbcp.jar CORE
3. Apache commons-logging-1.0.4.jar CORE
4. Apache commons-pool.jar CORE
5. dom4j-1.6.1.jar CORE
6. Apache log4j-1.2.11.jar CORE:DEV
7. Apache poi-3.1-FINAL-20080629.jar CORE:DEV
8. Apache poi-contrib-3.1-FINAL-20080629.jar CORE:OPTIONAL
9. Apache poi-scratchpad-3.1-FINAL-20080629.jar CORE:OPTIONAL
10. servlet-api.jar CORE:BUILD
11. jsp-api.jar CORE:BUILD
12. Oracle classes12.jar RUNTIME:OPTIONAL
13. MySQL mysql_connector.jar RUNTIME:OPTIONAL
14. SQLite sqlitejdbc-v053-pure.jar SAMPLE:OPTIONAL
15. SQLServer sqljdbc.jar RUNTIME:OPTIONAL
16. Spring Framework spring.jar RUNTIME:OPTIONAL
17. Hibernate RUNTIME:OPTIONAL