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 <l...@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 >>> mcg...@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 > mcg...@cartoonstudies.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha