I'm not sure how to help with that - maybe someone else on the list has an idea. --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce@liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ On Sat, Mar 28, 2009 at 2:58 AM, jksamyal <jksamyal@gmail.com> wrote:
Thanks very much nicole, its working now..
One more problem is there. While working in Koha, it automatically comes out of login and i have to log on again.
please guide me further...
Jatinder kumar
On Fri, Mar 27, 2009 at 3:57 PM, Nicole Engard <nicole.engard@liblime.com> 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@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha