- Project tools
- How do I...
|Over 500 more tools...
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.
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.
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
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
commons_lang both from apache.org
. Jdom will also have to be on you
classpath. Xerces is also used to
parse the XML file.