Kelechi, If the query is working, download and inspect the jdbc connection in the GL report to confirm you are connecting to the same database. Try editing the report and uploading it with a different name to test.
Jeff >-----Original Message----- >From: kelechi Micheals [mailto:[email protected]] >Sent: Tuesday, September 28, 2010 12:21 AM >To: A good place to start for users or folks new to Mifos. >Subject: Re: [Mifos-users] GL report issue > > > Hi Jeff, >This worked well for me. I have been using this to retrieve data, since >the parameters weren't working. > >On 09/27/2010 05:49 PM, Jeff Brewster wrote: >> Gayl, >> Try this query against your database to see if it returns results. >This >> will tell you if there is a problem specific to the BIRT report or >> whether there is data issue. Note the office_id below is "2", but in >> your query you need to match the office id for " Fantsuam Foundation >> Head Office": >> >> SELECT financial_trxn.posted_date, >> gl_code.glcode_value, >> SUM(IF(debit_credit_flag = 0, ABS(posted_amount), 0.000)) AS >debit, >> SUM(IF(debit_credit_flag = 1, ABS(posted_amount),0.000)) AS >credit >> FROM financial_trxn INNER JOIN gl_code USING (glcode_id) INNER JOIN >> account_trxn ON account_trxn.account_trxn_id = >> financial_trxn.account_trxn_id INNER JOIN account ON >account.account_id >> = account_trxn.account_id WHERE account.OFFICE_ID = 2 >> AND financial_trxn.posted_date>= '2010-08-01' >> AND financial_trxn.posted_date<= '2010-09-27' >> GROUP BY posted_date, glcode_value >> ORDER BY posted_date, glcode_value; >> >> >> Jeff >> >> >> ---------------------------------------------------------------------- >-------- >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing. >> http://p.sf.net/sfu/novell-sfdev2dev >> _______________________________________________ >> Mifos-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/mifos-users >> >> > > >-- >Kelechi B.G. Micheals >Programme Operations Manager >Fantsuam Foundation >Kafanchan > >+234-8020918229 >+234-7039642794 >[email protected] >skype: kelech_fantsuam > > >----------------------------------------------------------------------- - >------ >Start uncovering the many advantages of virtual appliances >and start using them to simplify application deployment and >accelerate your shift to cloud computing. >http://p.sf.net/sfu/novell-sfdev2dev >_______________________________________________ >Mifos-users mailing list >[email protected] >https://lists.sourceforge.net/lists/listinfo/mifos-users ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
