Hi Steve, This works for me: SELECT itemnumber, barcode, itemcallnumber FROM items WHERE itype=<<Item type|itemtypes>> You can find more info about the runtime paramters on the wiki too: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Parameters -Nick On Thu, May 1, 2014 at 4:33 PM, Steven Nickerson <snicker1@maine.rr.com>wrote:
Is there someone who can provide the SQL for me for a report that simply lists the itemnumber, barcode, and itemcallnumber for all items of a given Item Type. I'd like the report to prompt (with a pull-down) the list of all Item Types I have so that I can select it to report on. I think this should be easy but for some reason I can't get the pull-down list to populate with anything at all.
THANKS!
Steve
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Nick Clemens Quechee & Wilder Libraries Nick@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341