[Koha] Help with report

[Peel Lisa]

Hi Chris

Thank you! I did have a quick glance at those reports but obviously not close enough as I have now seen there is a report I can tweak to fit what I need.

You (and anyone else) will always be welcome to visit our school in Switzerland, we are located on the shores of Lake Geneva and not too far from Porte de Soleil, the biggest ski resort in Europe (ok, I've done my bit for the Swiss Tourist Board now:-)

Kind regards

Lisa

-----Original Message-----
From: Chris Cormack [mailto:chris at bigballofwax.co.nz] 
Sent: 09 February 2011 22:24
To: Peel Lisa
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Help with report

2011/2/10 Peel Lisa <lisa.peel at ritz.edu>:
> Hello
>
>
>
> Apologies for showing my complete ignorance of sql but I need to 
> create a report which lists catalogue records between two specific 
> call numbers (for example, 641.5 to 641.6) – I need it to list author, 
> title, edition and call number.
>
>
>
> Is there anything I can follow on the report wizard which will help me 
> create this report or is anyone kind enough to give me the sql which 
> would create this report?
>
>
Hi Lisa

Have you had a look here
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Catalog.2FBibliographic_Reports

Hopefully there is a report there that fits your needs, if not, sing out and when I get a chance i'll write something up.

All I ask in return, is a guided tour of the culinary arts school, should I ever visit Switzeraland again :)

Chris