From wiki.ginstr.com
Jump to: navigation, search

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