...
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.
...
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.
IV. Embedding Pentaho Report in MifosX
1. Create a '.mifosx' folder (use DOS to create the folder) in your home directory and then create a sub folder 'pentahoReports' in '.miofsxmifosx' folder.
2. Please copy the pentaho report file( with *.prpt extension) which you have created earlier using 'Penntaho Report Designer Tool' in "home/.mifosx/pentahoReports" folder.
3. Go to Community-app and then go to Admin >> System >> Manage Reports and click '+Create Report' to see the following window.
4. The Ensure 'Report Name' should be the same as the pentaho report file name (that is in this example, Activated Clients.prpt).
5. Select Report Type as 'Pentaho' from drop-down list.
6. Ensure to check the box for "Use report(UI)".
7. Select the required parameters which are passed to pentaho. (in this case, startDate, endDate)
78. Click on 'Submit' button to create the report.
V.
...
Generating created Pentaho Report
Go to Community-app and then go to 'Reports' tab and then by selecting the appropriate report. It is like using any other report by sending required parameters.the report section>>then the required report you could generate the report.
In this example: Reports>>clients>>Activated clients.