<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#333333">
<font size="-1"><font face="Verdana">Nicole,<br>
<br>
You can put your authorized value category code as your runtime
parameters in order to get their list of values when executing
your report.<br>
<br>
A simple example : SELECT * FROM borrowers WHERE sort1 =
<<<b><font color="#009900">Select borrower sort 1 value</font></b>|<b><font
color="#330099">Bsort1</font></b>>><br>
<br>
<font color="#009900"><b>In green</b></font>, the message you
want to display to the user at runtime.<br>
<font color="#000099"><b>In blue</b></font>, the authorized
value category code.<br>
<br>
Other than the category codes, you can have le list of branches
(branches), the patron category (categorycode), type of
documents (itemtype).<br>
<br>
<a class="moz-txt-link-freetext" href="http://manual.koha-community.org/3.4/en/reportsfaq.html">http://manual.koha-community.org/3.4/en/reportsfaq.html</a><br>
<br>
Regards,<br>
<br>
--<br>
Eric Bégin<br>
inLibro<br>
<br>
</font></font>On 2011-08-06 10:32, Nicole Engard wrote:
<blockquote
cite="mid:CAC0K6VH-weaxNNKEksdCJTji-49fHii9zFOBjZgMrgu9sANzbw@mail.gmail.com"
type="cite">
<pre wrap="">Hello all,
I'm the 'report guru' at work and while I love writing reports I'm
trying to think of ways to save me some work. One thing that I often
do is open up two tabs in my browser so that I have the authorized
values open in one and the report in another. I'm looking for some
brainstorming help on a way to make the pertinent values accessible
right from the reporting module (shelving locations, patron
categories, item types, collection codes, etc etc). I'm sure there
is some fancy way for us to embed links to important values or lists
of the important values on the create from SQL page ... or maybe just
one page with the values you'll need to query often.
Another option is to update the runtime parameters function to allow
for more pull down menus (right now it only has a pull down for
branches - that I know of).
Sorry for my jumbled thoughts, but that's what brainstorming is about :)
Nicole
_______________________________________________
Koha mailing list <a class="moz-txt-link-freetext" href="http://koha-community.org">http://koha-community.org</a>
<a class="moz-txt-link-abbreviated" href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a>
<a class="moz-txt-link-freetext" href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a>
</pre>
</blockquote>
</body>
</html>