Thank you, This works.
On Tue, Apr 30, 2024 at 5:21 PM Honest Chirozva <hon...@taatconsulting.com> wrote: > Hi Peter, > I think the reports are failing because you are using a PostgreSQL > database and the reports you are using are for MariaDB. > The SQL queries for the reports are MariaDB/MySQL compatible and will fail > when using a PostgreSQL database. > > 1. Try using a MariaDB database > 2. Or if you insist on PostgreSQL, you may need to change the queries > of the individual reports to PostgreSQL compatible queries. > > > > Regards. > > Honest Chirozva > Technical Consultant > > TAAT Consulting > > > ------------------------------ > *From:* PETER KIPROP <kipropli...@gmail.com> > *Sent:* Tuesday, April 30, 2024 2:52:36 PM > *To:* dev@fineract.apache.org <dev@fineract.apache.org> > *Subject:* PENTAHO REPORTS - Postgres > > Hello Dev, > I am trying to run pentaho reports with mifos, The deployment was > successful but i am facing a query error as attached below, > > The sample report i am running is as below > > > https://localhost:8443/Re-Bank/api/v1/runreports/Client%20Listing(Pentaho)?tenantIdentifier=default&locale=en&dateFormat=dd%20MMMM%20yyyy&R_selectOffice=1&output-type=PDF > > >
