Woo Hoo!! I am the one who put that in the manual and didn't remember that :) I still think we need a way from the build from sql page to view values easily ... still thinking of how to make it look good. Nicole On Sun, Aug 7, 2011 at 8:56 AM, Eric Bégin <Eric.Begin@inlibro.com> wrote:
Nicole,
You can put your authorized value category code as your runtime parameters in order to get their list of values when executing your report.
A simple example : SELECT * FROM borrowers WHERE sort1 = <<Select borrower sort 1 value|Bsort1>>
In green, the message you want to display to the user at runtime. In blue, the authorized value category code.
Other than the category codes, you can have le list of branches (branches), the patron category (categorycode), type of documents (itemtype).
http://manual.koha-community.org/3.4/en/reportsfaq.html
Regards,
-- Eric Bégin inLibro
On 2011-08-06 10:32, Nicole Engard wrote:
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 http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha