[Koha] Basics of report writing

Wagner, Jane jwagner at liblime.com
Fri Feb 11 03:09:32 NZDT 2011

There is a wiki page with some SQL reports people have shared at


It is possible to set up an external SQL connection to the Koha database,
and you would need to be _*very*_ careful about permissions with that
setup.  However, inside the Koha client itself, SQL reports are read-only.
The report interface is designed so that no one can modify the database by
running a report.

Other tools such as batch edit can modify data, of course, but the reports
are safe.

Jane Wagner

Senior Project Manager

LibLime, a division of PTFS

Content Management and Library Solutions

6400 Goldsboro Road, Suite 200

Bethesda, MD  20817

(301) 654-8088 x 151

jwagner at liblime.com <jwagner at ptfs.com>

*From:* koha-bounces at lists.katipo.co.nz [mailto:
koha-bounces at lists.katipo.co.nz] *On Behalf Of *Buster
*Sent:* Thursday, February 10, 2011 9:02 AM
*To:* Koha at lists.katipo.co.nz
*Subject:* [Koha] Basics of report writing

Hello. We are investigating Koha for our next automation system and I have a
couple of questions.

First, is there a basic manual or help file out there for the novice? Maybe
something that lists all of the possible terms and syntax structures, as
well as tells you how to get to the report writing area?

Second, we have a couple of supervisors with marginal computer expertise
(I'm sure that comes off as ironic from someone who would ask the first
question) who want to write their own reports. I'm nervous because in our
current system (Dynix Classic), a lot of damage can be done when one is at
the level for creating such reports, or has the security level to even get
there. Is that something to be concerned about with Koha?

Thanks for any help you can provide.

--Jim Maroon
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110210/99ed6b81/attachment.htm 

More information about the Koha mailing list