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@cartoonstudies.org
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@cartoonstudies.org _______________________________________________ Koha mailing list http://koha-community.org Koha@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
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@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@cartoonstudies.org _______________________________________________ Koha mailing list http://koha-community.org Koha@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@cartoonstudies.org
For the 1st, a CSV/tab delimited file is viewable in any text editor or spreadsheet program. I really like using Libre Office (http://www.libreoffice.org) for that as it's pretty smart about dealing with CSV and Tab delimited files. You can use MS Excel if you File -> Open the file, but it's not quite as slick as LO. As for your 2nd question, I believe you have your parameter set up incorrectly. Try this:
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=<<Item Type|itemtypes>> GROUP BY items.barcode,biblio.title,biblio.author,biblio.datecreated ORDER BY items.barcode asc,biblio.title asc,biblio.author asc,biblio.datecreated asc
You were missing an 's' on your itemtypes parameter declaration. :) Liz Rea NEKLS On Apr 25, 2011, at 1:37 PM, Caitlin McGurk wrote:
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@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@cartoonstudies.org _______________________________________________ Koha mailing list http://koha-community.org Koha@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@cartoonstudies.org
participants (2)
-
Caitlin McGurk -
Liz Rea