...
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.