I followed these steps: 1. Build New 2. Choose Cataloging 3. Choose Tabular 4. Choose 'barcode', 'call number', 'title', 'author' 5. Choose to limit on item type 'nonfic' and location 'adult' My final report looks like this: SELECT items.barcode,items.itemcallnumber,biblio.author,biblio.title FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype=<<itype|itemtype>> AND items.location='ADULT' ORDER BY items.itemcallnumber asc Everything is okay except for the item type which is not showing the actual item type I chose.
This seems to be working in current master.