[Koha] Brainstorm Help - Improve Reporting

[Eric Bégin]

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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110807/44bf7089/attachment.htm