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.be...@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 > > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha