I hope you all are stay safe.
Herewith attached customized report file called “Loan officer all transaction report” , Sample report with some explanation and Insert query for new parameter to stretchy_parameter table. Please follow the below steps.
NOTE : MifosX expertise, please check this and if this is okay, recommend for others.
Please go through attached sample report. It describe some columns and rows.
Then run the insert query to create new parameter. It is required to run the report.
(i) For Linux --> Please copy the pentaho report file in "/root/.mifosx/pentahoReports/" derectory
(ii) for Windows --> Please copy the pentaho report file in “home/.mifosx/pentahoReports” folder
- Go to Community-app and then go to Admin >> System >> Manage Reports and click ‘+Create Report’
Ensure ‘Report Name’ should be “Loan Officer All Transaction”
Select Report Type as ‘Pentaho’ from drop-down list.
Ensure to check the box for “Use report(UI)”.
Select the required parameters which are passed to pentaho. (as per the above screenshot).
Click on the ‘Submit’ button to create the report.
To run the report go to reports >> All >> type “Loan Officer All Transaction”
Email : firstname.lastname@example.org
Skype : Penta-Mi Pvt
Web : www.penta-mi.com
Facebook : www.facebook.com/Penta-Mi
(Attachment COTxnType Insert Query.sql is missing)
(Attachment Loan Officer All Transaction.prpt is missing)
(Attachment Sample report.xlsx is missing)