[Koha] fines list is not generated

[jatinder.KUMAR]

Thankyou very much nicole

Nicole Engard wrote:
> 
> Sounds like you need a custom report - I have one that gives me all
> the patrons with fines and the amount of the fine:
> 
> SELECT 
> borrowers.cardnumber,borrowers.surname,borrowers.firstname,FORMAT(SUM(accountlines.amountoutstanding),2)
> as due FROM borrowers LEFT JOIN accountlines on
> (borrowers.borrowernumber=accountlines.borrowernumber)  WHERE
> accountlines.amountoutstanding > 0 GROUP BY borrowers.cardnumber ORDER
> BY borrowers.surname asc
> 
> 
> ---
> 
> Nicole C. Engard
> Open Source Evangelist, LibLime
> (888) Koha ILS (564-2457) ext. 714
> nce at liblime.com
> AIM/Y!/Skype: nengard
> 
> http://liblime.com
> http://blogs.liblime.com/open-sesame/
> 
> 
> 
> On Thu, Mar 26, 2009 at 11:51 PM, jksamyal <jksamyal at gmail.com> wrote:
>> We are using Koha 3.0 version. Now we are closing the semester and
>>   exam are on. we want to generate a list of fines of defaulted
>>   students.
>>   Please guide me for this.
>>   jatinder kumar
>> _______________________________________________
>> Koha mailing list
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 

-- 
View this message in context: http://www.nabble.com/fines-list-is-not-generated-tp22735709p22754215.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.