Login | Register
My pages Projects Community openCollabNet

Chapter 1. Basics

Overview

Disclaimer

No liability for the contents of this document can be accepted. Use the concepts, examples and information at your own risk. There may be errors and inaccuracies, that could be damaging to your system. Proceed with caution, and although this is highly unlikely, the author(s) do not take any responsibility.

All copyrights are held by their by their respective owners, unless specifically noted otherwise. Use of a term in this document should not be regarded as affecting the validity of any trademark or service mark. Naming of particular products or brands should not be seen as endorsements.

General

eReport hopes to be an easy to use reporting tool to allow you to view your data in microsoft excel files. eReport is written in java to allow use on other operating systems other than windows. This will allow you to fetch data from most databases. To generate each report eReport parses a XML file created by you (maybe from within Eclipse using the Eclipse Plugin) and either creates or updates an Excel SpreadSheet using SQL and other information defined in the XML file. Fonts and colors etc. can be defined in the XML file for each cell and there is some support for formulas. There is no way to define a chart in the XML definition but if you have a spreadsheet with an existing chart or charts you can modify the information in the cells referenced by the chart or charts.

Requirements

To run eReport you will need a Java2 runtime environment and a computer capable of running it. eReport will not be of much use if you do not have a datasource of some kind that has a jdbc driver, eReport has been used with accounting packages such as BusinessVision32 (through jdbc-odbc bridge) as well as with linux RDBMS such as PostgreSQL and MySQL. The Eclipse plugin's visual designer will help you create your report definition file. Finally if you want to view your reports you will need Microsoft Excel. To use the eclipse plugin you must have Eclipse 2.1 and the eclipse GEF plugin 2.1 both available from www.eclipse.org

Please Note:

If you wish to use paramerterized SQL statments you need jdk1.4 as we use the regex packages which are new to jdk1.4.

This software also relies on several third party open souce libraries. You should not need to worry about this if you are running your reports from within Eclipse as the libraries are included in the plugin. If you are distributing your own application or creating reports standalone from batch files or shell scripts you will have to make sure these packages are included in your classpath. You will need poi and commons_lang both from apache.org . Jdom will also have to be on you classpath. Xerces is also used to parse the XML file.

Please Note:

To run the Eclipse plugin you will need the Eclipse Plugin GEF 2.1 installed.