[Koha] Problem constructing a report

Thu Jul 9 07:14:28 NZST 2009

I am trying to come up with a report that will list how many items were
checked out in each Dewey area, their barcode and date. If I could get
the author and title, that would be icing on the cake. I haven't figured
out the last part. However, I figured out this for the first part:

SELECT  items.datelastborrowed,items.barcode,items.itemcallnumber,
(TO_DAYS(06/01/2009))-TO_DAYS(06/30/2009)) FROM borrowers LEFT JOIN
statistics on (statistics.borrowernumber=borrowers.borrowernumber) LEFT
JOIN items on (items.itemnumber = statistics.itemnumber) LEFT JOIN
biblioitems on (biblioitems.biblioitemnumber = items.biblioitemnumber)
WHERE DATE (items.datelastborrowed) BETWEEN '2009-06-01' AND
'2009-06-30'

It shows that there are 3 pages of a report but when I run the report, I
receive the following message:

Content-type: text/html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

                       <html lang="en" xml:lang="en"
xmlns="http://www.w3.org/1999/xhtml">

                       <head><title>Koha Error</title></head>

                       <body>

<h1>Koha error</h1>

<p>The following fatal error has occurred:</p> 

                        <pre><code>Can't use an undefined value as an
ARRAY reference at /home/slb/_kohaclone/reports/guided_reports.pl line
461.

</code></pre>

<table>

<tr><th>Apache</th><td>  Server version: Apache/2.2.3

Server built:   Sep  8 2008 08:59:32

</td></tr>

<tr><th>Koha</th><td>    3.01.00.032</td></tr>

<tr><th>Koha DB</th><td> 3.0100032</td></tr>

<tr><th>MySQL</th><td>   mysql  Ver 14.12 Distrib 5.0.32

 for pc-linux-gnu (x86_64) using readline 5.2

</td></tr>

<tr><th>OS</th><td>      Linux shin.ec2.liblime.com 2.6.21.7-2.fc8xen #1
SMP Fri Feb 15 12:34:28 EST 2008 x86_64</td></tr>

<tr><th>Perl</th><td>    5.008008</td></tr>

</table></body></html>

I have constructed another report that gives me basically what I want
but shows everything that is checked out since we went live with the
system.  That SQL is:

SELECT  items.datelastborrowed,items.itemcallnumber,items.barcode, FROM
borrowers LEFT JOIN statistics on
(statistics.borrowernumber=borrowers.borrowernumber) LEFT JOIN items on
(items.itemnumber = statistics.itemnumber) LEFT JOIN biblioitems on
(biblioitems.biblioitemnumber = items.biblioitemnumber)  ORDER BY
items.datelastborrowed desc,items.itemcallnumber desc,items.barcode desc

So how do I get the date in example one to work with example 2?

Scotty

"You must try to generate happiness. If you aren't happy in one place,
chances are you  won't be happy anyplace" Ernie Banks, former Chicago
Cub

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090708/8f9e4a36/attachment-0001.htm 