Hi Cole Trumbo, There is a semicolon(;) at the end of your query, please remove the semicolon in your query at the end.
On Thu, Aug 13, 2015 at 4:56 AM, Ed Cable <[email protected]> wrote: > Forwarding along so the community can assist Cole. > > Ed > ---------- Forwarded message ---------- > From: Cole Trumbo <[email protected]> > Date: Wed, Aug 12, 2015 at 3:25 PM > Subject: Pentaho errors > To: [email protected] > > > Hi Ed, > > I got your email address from Cristina Lara-agudelo. I'm working on some > custom Pentaho reports, but I get errors when I try to put them on Mifos. > The error I have been stuck on recently is ...fails at query: select... and > then my query. > > Can you help me find out why they aren't working? I posted a question > about this on the knowledge portal here: > > http://mifos.cloud.answerhub.com/questions/836/why-do-my-pentaho-reports-fail-when-i-use-a-query.html > but it looks like nobody knows the answer. > > What I've tried: > The query looks like it is not HTML encoded because the error message > shows \n or \" , etc. So took the .prpt file, unzipped it, took the query > from sql-ds.xml, sent it through an HTML encoder, copy/pasted it back in, > saved, zipped, changed to .prpt, and uploaded it to Mifos again. But it > didn't work. I have manually changed all the " to " along with any > other characters that might be causing a problem, but it didn't work either. > > -- > > Best, > > Cole Trumbo > > 435.773.1488 mobile > > > > -- > *Ed Cable* > Director of Community Programs, Mifos Initiative > [email protected] | Skype: edcable | Mobile: +1.484.477.8649 > > *Collectively Creating a World of 3 Billion Maries | *http://mifos.org > <http://facebook.com/mifos> <http://www.twitter.com/mifos> > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > -- Regards Madhukar Lingala +91-8147121283 skype:lingala.madhukar
------------------------------------------------------------------------------
_______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
