Dear Mr. Paul. A Thank you so much for sharing this report. This is absolutely according to my need. Thanks again On Fri, Nov 1, 2013 at 8:28 PM, Paul A <paul.a@navalmarinearchive.com>wrote:

At 06:54 PM 11/1/2013 +0500, Saira Asghar wrote:

...

Hello Everyone

I need a report for list of items according to shelving location. If anyone has this kind of sql report then please send me or help me in generating this.

You might try:

SELECT biblio.author,biblio.title,**biblio.copyrightdate,items.** barcode,items.price,items.**dateaccessioned,items.** location,items.booksellerid FROM items, biblio WHERE items.biblionumber = biblio.biblionumber AND items.location = <<Pick your shelf (use auth. value)>> ORDER BY biblio.author ASC

then modify to suit your own needs.

Best - Paul

______________________________**_________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/**mailman/listinfo/koha<http://lists.katipo.co.nz/mailman/listinfo/koha>

-- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. E-mail: saira.asghar@namal.edu.pk Ph: 0459 236995 Ext. 138