Versions Compared

Old Version 17

changes.mady.by.user Sangamesh Nadagoudar

Saved on

compared with

New Version 18

changes.mady.by.user Sangamesh Nadagoudar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleQuery example

select mc.firstname,mc.lastname,mc.account_no from m_client mc
where mc.activation_date between ${startdate} and ${enddate}

 

    Image Removed Image Added  

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

...

     3.  Go to Community-app and then go to Admin >> System >> Manage Reports and click '+Create Report' to see the following window.

         Image RemovedImage Added

    4. 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.

...