Downloading
The Pentaho Report Design Wizard is available for download on Sourceforge at http://sourceforge.net/project/showfiles.php?group_id=140317&package_id=175834 as a compressed ZIP file.
Installation
Unzip the Report Design Wizard archive using your favorite unzip program to a location you will remember. A good choice, on Windows, might be "C:\pentaho-reportwizard". If you're using *NIX we assume you can find a safe location on your own. From this point forward we will refer to the installation path as {WIZARD-ROOT}. To follow this documentation it may be to your benefit to install the Pentaho sample data available from Sourceforge (http://sourceforge.net/project/showfiles.php?group_id=140317&package_id=175834) The Pentaho data ZIP file contains Hypersonic, which can be started by clicking the start-hypersonic.bat (Windows) or start-hypersonic.sh (*NIX). This database will be referenced throughout this documentation.
Configuration
The Report Design Wizard is distributed as a ZIP archive and comes pre-configured. There is no installation process or configuration other than unzipping.
If you are going to be using JNDI you must edit {WIZARD-ROOT}/ resources/solutions/system/simple-jndi/jdbc.properties. An example entry in this file would appear as follows.
SampleData/type=javax.sql.DataSource SampleData/driver=org.hsqldb.jdbcDriver SampleData/url=jdbc:hsqldb:hsql://localhost/sampledata SampleData/user=pentaho_user SampleData/password=password
SampleData is the name of the JNDI connection being setup, all of the name/value pairs configure the pertinent connection information. The */type setting tells JNDI what is being managed, in this case, a SQL datasource. The */driver setting is the JDBC driver class name for the database we're accessing. The */url is the JDBC connect string, the example shown here is for a Hypersonic database server running locally. The next two settings are the user's credentials for logging in to the database if required.
Database driver setup only requires that the drivers be located in the {WIZARD-ROOT}/lib/jdbc directory. A Hypersonic database driver is included with the Report Design Wizard under {WIZARD-ROOT}/lib/jdbc. Additional drivers may be dropped into this same location and they will be picked up by the application automatically.
The easiest type of connection to create is an XQuery connection. Using an XML data-file and a query we can walk through the wizard and generate a report-spec. There is an XML data-file in {WIZARD-ROOT}/samples/data called Quad_Data.xml. This file is the same data in the Hypersonic database.