Need help in Koha Report

[Ganesha]

Dear Friends,

  I am using koha open Source Software in our Library, When i generate report for Accession register am not getting  barcode & itemcallnumber in the report. it shows empty , ( I have uploaded bulk data through stage mark record import )

i have used this SQL codes

SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?
biblionumber=',biblio.biblionumber,'\">',biblio.biblionumber,'</a>') 

AS biblionumbers,         items.barcode, items.dateaccessioned, 

items.itemcallnumber, biblioitems.isbn, biblio.author, biblio.title, 

biblioitems.pages,         biblioitems.publishercode, biblioitems.place, 

biblio.copyrightdate  FROM items  LEFT JOIN biblioitems ON 

(items.biblioitemnumber=biblioitems.biblioitemnumber)  

LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) 

WHERE items.homebranch ='AVIO'  ORDER BY LPAD(items.barcode,40,' ') ASC

Thanks & Regards

Ganesha

Librarian

Bengaluru

[Ali Raza]

have u define 952$p in ur marc file

[Ganesha]

Yes,

i am generating report of Checkout and overdue and others am getting barcode of Book, but only in Accession Register Generate am getting above error.....

[Apurba Jyoti Majumder]

delete the line 

WHERE items.homebranch ='AVIO'

try this 

ORDER BY biblio.title ASC

instead of 

ORDER BY LPAD(items.barcode,40,' ') ASC

[Ganesha]

Hi Sir,

 No am getting same Error ,

i am generating report of Checkout and overdue and others am getting barcode of Book, but only in Accession Register Generate am getting above error.....

[Apurba Jyoti Majumder]

I will check again/...

[Apurba Jyoti Majumder]

be in touch in FB