...
7. Once you create executable Sql Query, you may have to add parameters if required. In order to embed Pentaho Report to MifosX, At least you have to create 3 parameters which are passed to MifosX, namely
- tenantUrl
- username
- password.
To add parameters, under the 'Data' tab, scroll down to see 'parameters' and then right click on 'parameters' and then click on 'Add parameter' to see the following window.
| Sl.No | Parameter Name | Parameter Fields |
|---|---|---|
| 1 | tenantUrl | Name:tenantUrl Label:Tenant Db Value type: String Default Value: jdbc:mysql://localhost:3306/mifostenant-default Check mandatory |
| 2 | username | Name:username Default Value: root |
| 3 | password | Name:password Default Value: mysql Check Mandatory Field |
Basically these three parameters are required to embed Pentaho Report in MifosX. Similarly, you can define more parameters as per requirement of the report.
8. Once you add the parameters, you need to check whether the report is working fine in the pentaho environment. First, You need to add the Report fields into 'Details' section of the pentaho environment. In our example, the fields 'firstname', 'lastname' and 'account_no' of the clients are added. In order to add them you need to drag each field in 'Details' section of the pentaho environment as shown in following two screenshots.
9. Next you need to click on 'Run' button and choose appropriate format for the report.
10. Once you 'Run' the report by choosing appropriate format, the following window should open where you enter the parameters and generate the report. (In this case, PDF is selected)
11. If you click on 'Ok' button and PDF is generated, it means Pentaho Report is created successfully.
12. You need to save the report with '.prpt' extension. In order to do it, Just go to the 'File' menu and click on 'Save' button.
