@stest
Before writing the query, you need to know what the each table( m_client,
m_group, m_loan, etc) fields(column headings) are..
Have you set up the database locally? If so, use HeidiSQL(front-end for
sql) software to know what each table contains.
If you want to generate report containing list of clients, try this query.
select mc.firstname, mc.lastname, mc.gender_cv_id
from m_client mc
On Wed, Jul 2, 2014 at 4:54 PM, Santosh Math <
[email protected]> wrote:
> @stest
>
> Before writing the query, you need to know what the each table( m_client,
> m_group, m_loan, etc) fields(column headings) are..
>
> Have you set up the database locally? If so, use HeidiSQL(front-end for
> sql) software to know what each table contains.
>
> If you want to generate report containing list of clients, try this query.
>
> select mc.firstname, mc.lastname, mc.gender_cv_id
> from m_client mc
>
>
> On Wed, Jul 2, 2014 at 4:23 PM, <[email protected]> wrote:
>
>> I am new user to mifosx first time trying to create simple report i hav
>> used the query select c.frist_name ,c.last_name ,c.account_number from
>> m.clients
>>
>>
>> went to reports->client->select the demo simple report wen click on run
>>
>>
>> ->I am getting this error.
>>
>> Internal Server Error [500]
>>
>> i cant see the fname and lastname and accno on the tab
>>
>>
>
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
