From wiki.ginstr.com
Jump to: navigation, search
m (→‎Used naming conventions for parameters: formatting)
m (formatting)
Line 8: Line 8:
 
=Install Report Designer=
 
=Install Report Designer=
  
−
#download Pentaho Report Designer 6.1
+
#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://sourceforge.net/projects/pentaho/files/Report%20Designer/6.1/prd-ce-6.1.0.1-196.zip/download
+
#[http://community.pentaho.com/projects/reporting/ Pentaho report designer Webpage]
−
#Pentaho report designer Webpage http://community.pentaho.com/projects/reporting/
+
#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 a Java SE Development Kit >= V7<br> 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)<br> and install the Java SE Development Kit
+
#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)
  
−
:URL: http://pentahodev.enaikoon.de:9090/pentaho (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

  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: 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 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
Retrieved from "http://wiki.ginstr.com/index.php?title=Pentaho_reports&oldid=10029"