Re: [Koha] Need with suppression report

2011-07-19 Thread Kathy Rippel
Thanks all, we'll check with Bywater, I guess. I don't know what mysql version they have us on. Kathy At 06:01 PM 7/19/2011, Chris Cormack wrote: 2011/7/20 Kathy Rippel : > I am trying to do a report of all items in a certain location that is NOT > suppressed. > > I

[Koha] Need with suppression report

2011-07-19 Thread Kathy Rippel
I am trying to do a report of all items in a certain location that is NOT suppressed. I went to the SQL report library and found the report by Chris Hobbs called Bibs Suppressed in OPAC. I figure if I can get that to work I can probably tweak it for the rest.However, I can't get this report to ru

[Koha] Help with report, please!

2011-04-13 Thread Kathy Rippel
I found Nicole's report in the SQL library for "Patrons with fines". I modified it to allow our libraries to choose their "branch". But it doesn't seem to run. Can someone show me where the problem is, please? Kathy --- SELECT borrowers.cardnumber, borrowe

[Koha] Need report help from the collection mind!

2011-03-29 Thread Kathy Rippel
I'm trying to build a simple weeding tool for one of my libraries and seem to be missing something. I am getting results where the Total_Circ is 2 or more!! The rest looks great, the results are just not narrow enough for this case. Context may be slightly different because we are on LLEK, but