Hi Peter, I believe there is a built-in default limit of 10000 for sql reports "to protect users from downloading too much or filling the server with an error"... I also understand that if you add a LIMIT statement to the sql then that takes precedence. So for example you could add " LIMIT 99999" to your sql and see if that works. It might be nice to have something either on-screen or in help about this. Good luck. Ian PS if you are subscribed to the normal Koha list that might be a better list for this question rather than development... On 25/11/2010 09:09, Peter Mwangi wrote:
Dear all, We have been trying to generate reports from KOHA. However, after building our report, we download it in excel and only get 10000 records (rows). We expect to get at least 40,000 records. Where could we be going wrong or rather what are we doing or not doing? Is this a koha or excel- related challenge?
_______________________________ Peter Mwangi Gichiri Systems Librarian, NEGST/ Africa International University P.O.Box, 24686 - 00502 Karen, Nairobi Tel: 254 (02) 882104/5; Cell: 0721 - 621692 Email: peter.mwangi@negst.edu Website: www.negst.edu _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Ian Bays Director of Projects PTFS Europe.com mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com