Pentaho reports

Pentaho reports are used to transform all stored data into meaningful information.

To learn how to initiate report generation from ginstr app, click here.

Install Report Designer

1. Download Pentaho Report Designer 6.1
2. Pentaho report designer Webpage
3. Extract prd-ce-6.1.0.1-196.zip in tools\pentaho\ directory (you can use any other directory, however this wiki uses tools\pentaho\)
4. Copy attached MySQL JDBC Driver to tools\pentaho\report-designer\lib\jdbc
5. Create directory /opt/pentaho/data-integration/transformations (C:\opt\pentaho\data-integration\transformations on Windows)
6. Copy attached *.ktr files to /opt/pentaho/data-integration/transformations (TBD: use SVN or try to find DB solution)
7. You need to have Java SE Development Kit ≥ V7 installed (download from here or here).
8. Start Pentaho report designer. On Windows use tools\pentaho\report-designer\report-designer.bat

Open Report template from server repository

Report name for GINSTRAPP report in ginstr is GINSTRAPP_report. (e.g. bebra_report)

Report name for 1st test in inViu pro is mysql_test_report

Menu: File -> Open from repository

Enter the following URL: https://pentahodev.enaikoon.de/pentaho (valid credentials must be provided)

Location: public/reports/ginstr

File Name: [report name].prpt

Save Report template on server

Menu: File -> Publish...

URL: https://pentahodev.enaikoon.de/pentaho (valid credentials must be provided)

Location: public/reports/ginstr

File Name: [report name]

Server repository location

ginstr reads all report templates from public/reports/ginstr

inViu Pro classic reads all report templates from public/reports/ip

inViu Pro black reads all report templates from public/reports/ip

Used naming conventions for parameters

Parameter	Description
_ticket	set to used ticket of user
_company	set to company of user
_keys	set to keys of selected rows
_imageServer	set to server which hosts the images. Usally the ginstr server.
_dateFormat	set to date format string of the user. eg. dd.MM.yyyy
_timeFormat	set to time format string of the user. eg. hh:mm:ss
_dateTimeFormat	set to date format string of the user. eg. dd.MM.yyyy hh:mm:ss

For date, time and dateTime it is possible to create 'interval' filter.

Parameter name must start with _intervalBegin_ for begin of interval.

For end of interval parameter name must start with _intervalEnd_.

e.g interval for dateTime value created.

Parameter names

_intervalBegin_created

_intervalEnd_created

SQL query

select * from table where created between $1 and $2

$1 is set to _intervalBegin_created

$2 is set to _intervalEnd_created