Accession Register Customize
- Crete the New SQL Report
- Copy and Paste following lines in the SQL report. Save and close.
SELECT items.Barcode,biblioitems.biblionumber,items.itemcallnumber AS 'Call Number',biblio.Author,biblio.Title AS Titles,biblioitems.size As 'Bill No', biblioitems.Pages, biblioitems.Editionstatement AS Edition,biblio.Copyrightdate AS Year,items.Price,biblioitems.illus AS 'OPAC Price',biblioitems.publishercode AS Publisher,biblioitems.Place AS 'Place of Publication',biblio.unititle AS Subject,items.ccode AS Collection,items.location AS 'Department Wise', items.itype AS 'Book Status / Item type',biblioitems.itemtype AS Department,biblioitems.url AS OnlineURL,items.Dateaccessioned,biblioitems.ISBN,biblio.notes As ' General Notes/Remarks',biblio.Serial,items.Issues,items.Renewals
FROM items
LEFT JOIN biblioitems ON (items.biblioitemumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblnio.biblionumber)
ORDER BY LPAD(items.barcode,40,' ') ASC
Run Report
){kind=link}
3 Comments
I have put Bill No. in 541$b, Bill Date 541$d and subject in 650$a. Please customise the accession register report including these fields.
ReplyDeleteThe Fields you asked for are updated.
DeleteBill No. in 300$c, Bill Date 300$e and subject in 650$a.
thank you for sharing this wonderfull article we also provide (SEO, Digital Marketing, business, Affiliate Marketing, Earn Money Online, Instagram marketing, blogging or blogger Couses for free) and much more like news andall other tech things, i wish that you will wonder here.
ReplyDelete