Page Comparison

...

5. As shown in the following window click on '+' button to add the sql query.

6.  Here, provide Provide the Sql Query Name and write the appropriate Sql Query and then click on 'Preview' button to confirm the Sql query executed successfully. Then click on 'Ok' button.

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.
  Image Added
  
  

  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 Label:User Name Value Type: String Default Value: root
  3	password	Name:password Label:Password Value Type: String 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.