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
