m (→Used naming conventions for parameters: formatting) |
m (formatting) |
||
Line 8: | Line 8: | ||
=Install Report Designer= | =Install Report Designer= | ||
− | # | + | #Download [http://sourceforge.net/projects/pentaho/files/Report%20Designer/6.1/prd-ce-6.1.0.1-196.zip/download '''Pentaho Report Designer 6.1'''] |
− | + | #[http://community.pentaho.com/projects/reporting/ Pentaho report designer Webpage] | |
− | # | + | #Extract <code>prd-ce-6.1.0.1-196.zip</code> in <code>tools\pentaho\ directory</code> (you can use any other directory, however this wiki uses <code>tools\pentaho\</code>) |
− | #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 <code>tools\pentaho\report-designer\lib\jdbc</code> |
− | #Copy attached MySQL JDBC Driver to tools\pentaho\report-designer\lib\jdbc | + | #Create directory <code>/opt/pentaho/data-integration/transformations</code> (<code>C:\opt\pentaho\data-integration\transformations</code> on Windows) |
− | #Create directory /opt/pentaho/data-integration/transformations (C:\opt\pentaho\data-integration\transformations on Windows) | + | #Copy attached *.ktr files to <code>/opt/pentaho/data-integration/transformations</code> (TBD: use SVN or try to find DB solution) |
− | #Copy attached *.ktr files to /opt/pentaho/data-integration/transformations (TBD: use SVN or try to find DB solution) | + | #You need to have '''Java SE Development Kit ≥ V7''' installed (download from [http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html here] or [http://www.oracle.com/technetwork/java/javase/downloads/index.html here]). |
− | #You need | + | #Start Pentaho report designer. On Windows use <code>tools\pentaho\report-designer\report-designer.bat</code> |
− | #Start Pentaho report designer. On Windows use tools\pentaho\report-designer\report-designer.bat | ||
=Open Report template from server repository= | =Open Report template from server repository= | ||
− | :Report name for GINSTRAPP report in ginstr is GINSTRAPP_report. (e.g. bebra_report) | + | :Report name for GINSTRAPP report in ginstr is <code>GINSTRAPP_report</code>. (e.g. <code>bebra_report</code>) |
− | :Report name for 1st test in inViu pro is mysql_test_report | + | :Report name for 1st test in inViu pro is <code>mysql_test_report</code> |
− | :Menu: File->Open from repository | + | :Menu: File -> Open from repository |
− | :Enter the following. | + | :Enter the following URL: <code>http://pentahodev.enaikoon.de:9090/pentaho</code> (valid credentials must be provided) |
− | + | :Location: <code>public/reports/ginstr</code><br> | |
− | + | :File Name: <code>[report name].prpt</code><br> | |
− | :Location: public/reports/ginstr<br> | ||
− | :File Name: [report name].prpt<br> | ||
=Save Report template on server= | =Save Report template on server= | ||
− | :Menu: File-> Publish... | + | :Menu: File -> Publish... |
− | :URL: http://pentahodev.enaikoon.de:9090/pentaho (valid credentials must be provided) | + | :URL: <code>http://pentahodev.enaikoon.de:9090/pentaho</code> (valid credentials must be provided) |
− | :Location: public/reports/ginstr<br> | + | :Location: <code>public/reports/ginstr</code><br> |
− | :File Name: [report name] | + | :File Name: <code>[report name]</code> |
=Server repository location= | =Server repository location= | ||
− | :ginstr reads all report templates from public/reports/ginstr<br> | + | :ginstr reads all report templates from <code>public/reports/ginstr</code><br> |
− | :inViu Pro classic reads all report templates from public/reports/ip<br> | + | :inViu Pro classic reads all report templates from <code>public/reports/ip</code><br> |
− | :inViu Pro black reads all report templates from public/reports/ip | + | :inViu Pro black reads all report templates from <code>public/reports/ip</code> |
=Used naming conventions for parameters= | =Used naming conventions for parameters= |
Revision as of 16:57, 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
- Pentaho report designer Webpage
- Extract
prd-ce-6.1.0.1-196.zip
intools\pentaho\ directory
(you can use any other directory, however this wiki usestools\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 to have Java SE Development Kit ≥ V7 installed (download from here or here).
- 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