m (→Used naming conventions for parameters: formatting) |
|||
Line 55: | Line 55: | ||
! scope="col" | Description | ! scope="col" | Description | ||
|- | |- | ||
− | | _ticket | + | | <code>_ticket</code> |
| set to used ticket of user | | set to used ticket of user | ||
|- | |- | ||
− | | _company | + | | <code>_company</code> |
| set to company of user | | set to company of user | ||
|- | |- | ||
− | | _keys | + | | <code>_keys</code> |
| set to keys of selected rows | | set to keys of selected rows | ||
|- | |- | ||
− | | _imageServer | + | | <code>_imageServer</code> |
| set to server which hosts the images. Usally the ginstr server. | | set to server which hosts the images. Usally the ginstr server. | ||
|- | |- | ||
− | | _dateFormat | + | | <code>_dateFormat</code> |
| set to date format string of the user. | | set to date format string of the user. | ||
− | eg. dd.MM.yyyy | + | eg. <code>dd.MM.yyyy</code> |
|- | |- | ||
− | | _timeFormat | + | | <code>_timeFormat</code> |
| set to time format string of the user. | | set to time format string of the user. | ||
− | eg. hh:mm:ss | + | eg. <code>hh:mm:ss</code> |
|- | |- | ||
− | | _dateTimeFormat | + | | <code>_dateTimeFormat</code> |
| set to date format string of the user. | | set to date format string of the user. | ||
− | eg. dd.MM.yyyy hh:mm:ss | + | eg. <code>dd.MM.yyyy hh:mm:ss</code> |
|- | |- | ||
|} | |} | ||
− | :For date, time and dateTime it is possible to create 'interval' filter. Parameter name | + | :For date, time and dateTime it is possible to create 'interval' filter. |
− | :e.g interval for dateTime value created. | + | ::Parameter name must start with <code>_intervalBegin_</code> for begin of interval. |
− | + | ::For end of interval parameter name must start with <code>_intervalEnd_</code>. | |
− | + | :::e.g interval for dateTime value created. | |
− | |||
− | : | + | :;Parameter names: |
− | : | + | ::<code>_intervalBegin_created</code><br> |
+ | ::<code>_intervalEnd_created</code> | ||
− | :$1 is set to _intervalBegin_created<br> | + | :;SQL query: |
− | :$2 is set to _intervalEnd_created | + | ::select * from table where created between <code>$1</code> and <code>$2</code> |
+ | |||
+ | :::<code>$1</code> is set to <code>_intervalBegin_created</code><br> | ||
+ | :::<code>$2</code> is set to <code>_intervalEnd_created</code> |
Revision as of 16:47, 12 July 2017
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