Downloading Pentaho Report Designer
Pentaho Report Designer is a reporting tool which can be downloaded from sourceforce. Mifos supports Pentaho Report Designer 3.6.0-stable. To download appropriate version it is necessary to follow the steps below:
- Go to http://reporting.pentaho.com/ page
- Find Reporting Creation Tools section and click on Downloads link
- It’ll send You to sourceforce page
- Select 3.6.0-stable link from the list
- Choose archive file from the list to download it
- Extract downloaded archive
...
The application can be executed using report-designer.bat, report-designer.sh in unix or by launcher.jar which are in Pentaho Report Designer directory. The first step in creating a report is to create blanc report template. You can do this by choosing ‘New Report’ from Welcome window or by choosing File -> New
...
Next step is to choose Data->Add datasource->JDBC from Report Designer menu. It will open JDBC Data Source window. To add connection to local Mifos database You have to click on ‘Add a new connection’ button:
In the new form window set the database connection settings:
...
To verify connection You can click on ‘Test’ button. If everything is OK ok then Message Box will appear:
...
In ‘JDBC Data Source’ window there are three other fields: ‘Available Queries’, ‘Query Name’ , and ‘Query’. These fields are responsible for the management of queries sent to the database. Field ‘Available Queries’ is a list of queries which were added by User, ‘Query Name’ give You possibility to edit name of actually chosen query and ‘Query’ field contains queries written in SQL language, which are sent to the database in order to obtain data. Queries are saved only for report, not for connection!
Let’s try to add some query.
- From Connections list select ‘Mifos’.
- Click on ‘Add Query...’ button, ‘Query 1’ will appear on ‘Available Queries’ and ‘Query Name’ field. You can change it’s name.
- Click on yellow line on ‘Query’ field to start writing querySQL command
- Type: SELECT * FROM customer
...
If You have some customers on Your Mifos instance then after clicking ‘Preview’ button You will see informations about them. This query is just example. You can select data from other tables, and using specific parameters use other SQL commands .
Click on ok and go to Report Designer Editor. On right side of the screen You can see sidebar with to two tabs: ‘Structure’ and ‘Data’. Choose ‘Data’ and double click on ‘Data Sets’, You will see that JDBC (Mifos) connection , under has been added to Data Sets. Under this connection You will find recently added query (Query 1) and whole data from 'customer' table.
Displaying a field in the final report is very easy, simply click on it's name and drag the field on to the Details bandReport Area.
If You want to check if it works just click on ‘Run’ button (green triangle) from task bar.