[Koha] Brainstorm Help - Improve Reporting

[Nicole Engard]

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 at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>