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
- download Pentaho Report Designer 6.1
- http://sourceforge.net/projects/pentaho/files/Report%20Designer/6.1/prd-ce-6.1.0.1-196.zip/download
- Pentaho report designer Webpage http://community.pentaho.com/projects/reporting/
- 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\)
- Copy attached MySQL JDBC Driver to tools\pentaho\report-designer\lib\jdbc
- Create directory /opt/pentaho/data-integration/transformations (C:\opt\pentaho\data-integration\transformations on Windows)
- Copy attached *.ktr files to /opt/pentaho/data-integration/transformations (TBD: use SVN or try to find DB solution)
- You need a Java SE Development Kit >= V7
download from http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html (or http://www.oracle.com/technetwork/java/javase/downloads/index.html)
and install the Java SE Development Kit - 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: http://pentahodev.enaikoon.de:9090/pentaho (valid credentials must be provided)
- Location: public/reports/ginstr
- File Name: [report name].prpt
Save Report template on server
- Menu: File-> Publish...
- URL: http://pentahodev.enaikoon.de:9090/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 name must start with
- 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