If you are comfortable with Perl, what I do quite often is create in the folder koha\intranet\cgi-bin\test the MyReport.pl that points a template MyReport.tt in koha\htdocs\intranet-tmpl\prog\en\modules\test. This way you can create an input form however you like. MyReport.pl would execute the SQL query and display the results in a table in MyReport.tt. What I do now is usually modify one of my reports when I need a new one. The first time I used one of the existing scripts and slowly modified it until I felt comfortable with the process. Hope this helps. Jorge

Hi All - I want to set up a SQL report that can take a variable number of

the same value. My SQL looks like:

select biblionumber, concat (branchname, ', ', lib) as location, itemcallnumber, if(onloan is null,'Available',onloan) onloan from items,authorised_values,branches where biblionumber in (<<BIBIDS>>) and authorised_values.category = 'LOC' and items.location = authorised_values.authorised_value and items.homebranch = branches.branchcode

I want the <<BIBIDS>> value to be able to receive several values when I

run the report from the staff client, but I cannot get it to work. Any advice/tips much welcome!

Stephen

Stephen Graham Online Information Manager Information Collections and Services Library and Computing Services University of Hertfordshire Hatfield AL10 9AB UK Tel. 01707 286111 Ext: 77751 Email s.graham4@herts.ac.uk

-- Jorge de Cardenas | Head Systems Administrator 3512 Darrow Road, Stow, OH 44224 330 688-3295, ext 106 | FAX 330 688-0448 | www.smfpl.org | <http://www.facebook.com/SMFPL> <http://twitter.com/smfpl> <http://pinterest.com/smfpl/boards> If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the institution.