[Koha] reports function

[Caitlin McGurk]

This is the SQL I'm trying to run and export in something other than
.tab or .csv:
SELECT  borrowers.cardnumber,borrowers.surname,borrowers.firstname,borrowers.email,
FROM borrowers   WHERE borrowers.branchcode='H25C'

This is the SQL I'd like to run for cataloged books:
SELECT sum(items.barcode),sum(biblio.title),sum(biblio.author),sum(biblio.datecreated),
items.barcode,biblio.title,biblio.author,biblio.datecreated FROM items
LEFT JOIN biblioitems on
(items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio
on (biblioitems.biblionumber=biblio.biblionumber)   WHERE
items.itype=<<itype|itemtype>> GROUP BY
items.barcode,biblio.title,biblio.author,biblio.datecreated ORDER BY
items.barcode asc,biblio.title asc,biblio.author
asc,biblio.datecreated asc

Regards,
CM

On Mon, Apr 25, 2011 at 2:15 PM, Liz Rea <lrea at nekls.org> wrote:
>
> On Apr 25, 2011, at 1:06 PM, Caitlin McGurk wrote:
>
>> When commanding a report to run, Koha asks me to "Enter parameters for
>> report Cataloged Books:", with a bar below it that says "itype:" and
>> has an empty scroll bar with no choices to pick from. When I click
>> run, nothing happens. Anyone know what this means or how to fix it?
>>
>> Also, is there a way to export reports in any format other than a .csv
>> or .tab? Neither of these are viewable on my machine.
>>
>> Thanks!
>> Caitlin McGurk
>>
>> --
>> Caitlin McGurk
>> Librarian
>> The Schulz Library
>> The Center for Cartoon Studies
>> McGurk at cartoonstudies.org
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>
> Caitlin,
> Can you paste us the sql of the report you are trying to run?
>
> Liz Rea
> NEKLS
>



-- 
Caitlin McGurk
Librarian
The Schulz Library
The Center for Cartoon Studies
McGurk at cartoonstudies.org