[Koha] reports function

[Liz Rea]

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 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