Dear Daniel, I applied the SQL query in Tools > Reports > Guided Reports Wizard > Create from SQL. I saved the csv file. But CSV file contain the following message, <h1>Koha error</h1> <p>The following fatal error has occurred:</p> <pre><code>Can't use an undefined value as an ARRAY reference at /usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl line 461. </code></pre> <table> Can you check what the problem happened while generating report? Following is the SQL query for the reference of other community members who have interest in this topic, SELECT extractValue(marcxml," collection/record/datafield[@tag='952'][1]/subfield[@code='p']"), extractValue(marcxml,"collection/record/datafield[@tag='024'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='020'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='100'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='245'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='650'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='500'][1]/subfield[@code='a]"), extractValue(marcxml,"collection/record/datafield[@tag='520'][1]/subfield[@code='a']"), extractValue(marcxml,"collection/record/datafield[@tag='650'][1]/subfield[@code='a']") FROM biblioitems I request other community members attention to this topic. Regards -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White