Hi,
Center name was missing select client.display_name as CLIENT_NAME, account.global_account_num as ACCOUNT_NUM, lookup_value.lookup_name as SAVINGS_TYPE, grp.display_name as GROUP_NAME, center.display_name as CENTER_NAME, savings_account.SAVINGS_BALANCE from customer center inner join customer grp on grp.parent_customer_id=center.customer_id inner join customer client on client.parent_customer_id=grp.customer_id inner join account on account.customer_id=client.customer_id inner join savings_account on savings_account.account_id=account.account_id inner join savings_type on savings_type.savings_type_id=savings_account.savings_type_id inner join lookup_value on lookup_value.lookup_id=savings_type.lookup_id where account.account_state_id=16 Ramya From: [email protected] [mailto:[email protected]] Sent: Thursday, March 31, 2011 5:59 PM To: [email protected] Subject: Re: [Mifos-users] sql query challenge Hi Tajudeen, I think this may help select client.display_name as CLIENT_NAME, account.global_account_num as ACCOUNT_NUM, lookup_value.lookup_name as SAVINGS_TYPE, grp.display_name as GROUP_NAME, savings_account.SAVINGS_BALANCE from customer center inner join customer grp on grp.parent_customer_id=center.customer_id inner join customer client on client.parent_customer_id=grp.customer_id inner join account on account.customer_id=client.customer_id inner join savings_account on savings_account.account_id=account.account_id inner join savings_type on savings_type.savings_type_id=savings_account.savings_type_id inner join lookup_value on lookup_value.lookup_id=savings_type.lookup_id where account.account_state_id=16 Thanks, Ramya From: Tajudeen Balogun [mailto:[email protected]] Sent: Thursday, March 31, 2011 5:38 PM To: [email protected] Subject: [Mifos-users] sql query challenge Hi all, I have successfully installed version 2.02 and every thing seems to be doing okay. by the way i got that to work on window2003 but i have a challenege with report specifically the correct sql statement to enable me generate a report that list all active savings account clients and their balances everyday. the report should contain client name, account number, saving type (voluntary or mandatory), group,center and balance will appreciate any help from the community. Gracious Tajudeen Balogun CEO, Infosol Nigeria Limited.(System Integrators, Software Developers and Computer Forensics)Suite E322 & H134 Ikota Shopping Complex, VGC Lagos, Nigeria.cell 234-803 8949 297
------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
