RE: [Mifos-users] hi , i have created the DayBook report, Active clients on date report and also Demand sheet for for JLG loans .

2018-06-23 Thread sifiso
By the way that query works fine in stretchy reports and not yet tested in pentaho. I have also attached the query for collections report that has been customised so that it shows the transactions that were made between the start and end date that are entered instead of showing the creation date

Re: [Mifos-users] hi , i have created the DayBook report, Active clients on date report and also Demand sheet for for JLG loans .

2018-06-23 Thread Santosh Math
Sifiso, I just tested. Input parameters office and start date, right? On Sat 23 Jun, 2018, 1:48 PM , wrote: > Hi Santosh, > > > > I have noticed that the select concat queries that run in stretchy reports > and pentaho do not run in the database directly. They produce errors there. > All the

RE: [Mifos-users] hi , i have created the DayBook report, Active clients on date report and also Demand sheet for for JLG loans .

2018-06-23 Thread sifiso
Hi Santosh, I have noticed that the select concat queries that run in stretchy reports and pentaho do not run in the database directly. They produce errors there. All the queries in the pentaho reports in Mifos perform the same way. I have a simulation attached for active client loans as at