<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
--></style></head><body lang="EN-US" link="blue" vlink="purple"><div class="WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D">There is a wiki page with some SQL reports people have shared at </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D"><a href="http://wiki.koha-community.org/wiki/SQL_Reports_Library">http://wiki.koha-community.org/wiki/SQL_Reports_Library</a></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D">It is possible to set up an external SQL connection to the Koha database, and you would need to be _<i>very</i>_ 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.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D">Other tools such as batch edit can modify data, of course, but the reports are safe.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:Consolas;color:#1F497D">Jane Wagner</span></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:Consolas;color:#1F497D">Senior Project Manager</span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:Consolas;color:#1F497D">LibLime, a division of PTFS</span></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:Consolas;color:#1F497D">Content Management and Library Solutions</span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:Consolas;color:#1F497D">6400 Goldsboro Road, Suite 200</span></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:Consolas;color:#1F497D">Bethesda, MD  20817</span></p><p class="MsoNormal"><span style="font-size:10.5pt;font-family:Consolas;color:#1F497D">(301) 654-8088 x 151</span></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:Consolas;color:#1F497D"><a href="mailto:jwagner@ptfs.com">jwagner@liblime.com</a></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D"> </span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;">From:</span></b><span style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;"> <a href="mailto:koha-bounces@lists.katipo.co.nz">koha-bounces@lists.katipo.co.nz</a> [mailto:<a href="mailto:koha-bounces@lists.katipo.co.nz">koha-bounces@lists.katipo.co.nz</a>] <b>On Behalf Of </b>Buster<br>
<b>Sent:</b> Thursday, February 10, 2011 9:02 AM<br><b>To:</b> <a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br><b>Subject:</b> [Koha] Basics of report writing</span></p></div><p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>Hello. We are investigating Koha for our next automation system and I have a couple of questions.<br><br>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? <br>
<br>Second, we have a couple of supervisors with marginal computer expertise (I&#39;m sure that comes off as ironic from someone who would ask the first question) who want to write their own reports. I&#39;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?<br>
<br>Thanks for any help you can provide.<br><br>--Jim Maroon<br><br></p></div></body></html>