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