Dear Daniel,<br><br>I applied the SQL query in Tools &gt; Reports &gt; Guided Reports Wizard &gt; Create from SQL.<br>I saved the csv file.<br>But CSV file contain the following message,<br><br><br>



        
        <meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
        <title></title>
        <meta name="GENERATOR" content="OpenOffice.org 3.0  (Linux)">
        <style>
                <!-- 
                BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Arial"; font-size:x-small }
                 -->
        </style>
        

<table rules="none" border="0" cellspacing="0" cols="1" frame="void">
        <colgroup><col width="923"></colgroup>
        <tbody>
                <tr>
                        <td width="923" align="left" height="17">                                                &lt;h1&gt;Koha error&lt;/h1&gt;</td>
                </tr>
                <tr>
                        <td align="left" height="17">                                                &lt;p&gt;The following fatal error has occurred:&lt;/p&gt; </td>
                </tr>
                <tr>
                        <td align="left" height="17">                        &lt;pre&gt;&lt;code&gt;Can&#39;t use an undefined value as an ARRAY reference at /usr/share/koha/intranet/cgi-bin/reports/<a href="http://guided_reports.pl">guided_reports.pl</a> line 461.</td>

                </tr>
                <tr>
                        <td align="left" height="17">&lt;/code&gt;&lt;/pre&gt;</td>
                </tr>
                <tr>
                        <td align="left" height="17">                                                &lt;table&gt;<br><br></td>
                </tr>
        </tbody>
</table>
<br clear="all">Can you check what the problem happened while generating report?<br><br>Following is the SQL query for the reference of other community members who have  interest in this topic,<br><br>SELECT<br>
extractValue(marcxml,&quot;<div id=":8x" class="ii gt">collection/record/datafield[@tag=&#39;952&#39;][1]/subfield[@code=&#39;p&#39;]&quot;),<br>
<br>
extractValue(marcxml,&quot;collection/record/datafield[@tag=&#39;024&#39;][1]/subfield[@code=&#39;a&#39;]&quot;),<br>
<br>
extractValue(marcxml,&quot;collection/record/datafield[@tag=&#39;020&#39;][1]/subfield[@code=&#39;a&#39;]&quot;),<br>
<br>
extractValue(marcxml,&quot;collection/record/datafield[@tag=&#39;100&#39;][1]/subfield[@code=&#39;a&#39;]&quot;),<br>
<br>
extractValue(marcxml,&quot;collection/record/datafield[@tag=&#39;245&#39;][1]/subfield[@code=&#39;a&#39;]&quot;),<br>
<br>
extractValue(marcxml,&quot;collection/record/datafield[@tag=&#39;650&#39;][1]/subfield[@code=&#39;a&#39;]&quot;),<br>
<br>
extractValue(marcxml,&quot;collection/record/datafield[@tag=&#39;500&#39;][1]/subfield[@code=&#39;a]&quot;),<br>
<br>
extractValue(marcxml,&quot;collection/record/datafield[@tag=&#39;520&#39;][1]/subfield[@code=&#39;a&#39;]&quot;),<br>
<br>
extractValue(marcxml,&quot;collection/record/datafield[@tag=&#39;650&#39;][1]/subfield[@code=&#39;a&#39;]&quot;)<br>
FROM    biblioitems</div><br><br>I request other community members attention to this topic.<br><br>Regards<br>-- <br>Vimal Kumar V.<br>Asst. Librarian<br>Asian School of Business<br>Technopark, Trivandrum-695 581<br>Web: <a href="http://www.vimalkumar.co.nr">www.vimalkumar.co.nr</a><br>
Blog: <a href="http://vimalkumar.oksociety.in">http://vimalkumar.oksociety.in</a><br><br>OK Society Volunteer. <a href="http://oksociety.in">http://oksociety.in</a><br>---------------------------------------------------------------------------<br>
&quot;I forget what I was taught. I only remember what I have learnt&quot;<br>-Patrick White<br>