...
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 |
| 4 | startdate (For this example) | Name:startdate Display Type: Date Picker |
| 5 | enddate (For this example) | Name:enddate Display Type: Date Picker |
Basically, these three parameters are required to embed Pentaho Report in MifosX. Similarly, you can define more parameters as per requirement of the report.
...
10. Once you 'Run' the report by choosing appropriate format, the following window will open where you enter the parameters and generate the report. (In this case, PDF is selected).
11. If you click on the 'OK' button and a PDF is generated, it means Pentaho Report was created successfully.
...
7. Select the required parameters which are passed to pentaho. (in this case, startDate, endDate).
8. Click on the 'Submit' button to create the report.
...