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
