<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
I was confused why my custom report wasn't showing me what I thought it should. Running the same query in the MySQL command-line gave me 22 rows, but the equivalent Koha report only showed 20 rows. Finally, with some MySQL logging and grep'ing, I found this:<br><br>/usr/share/koha/lib/C4/Reports.pm<br>lines 335-340<br><br> # take this line out when in production<br> if ($format eq 'csv' or $format eq 'tab'){<br> }<br> else {<br> $sql .= " LIMIT 20";<br> }<br><br><br>So, er, could those lines be taken out? :-)<br><br><br><br /><hr />Back to work after baby– <a href='http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=5797498&ocid=T067MSN40A0701A' target='_new'>how do you know when you’re ready?</a></body>
</html>