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 <[email protected]> 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 >> [email protected] >> _______________________________________________ >> Koha mailing list http://koha-community.org >> [email protected] >> 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 [email protected] _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
