| Lines 1-14
          
      
      
        Link Here | 
        
          | 1 | [% INCLUDE 'doc-head-open.inc' %] | 1 | [% INCLUDE 'doc-head-open.inc' %] | 
          
            
              | 2 | <title>Koha › Reports › Guided Reports Wizard  | 2 | <title>Koha › Reports › Guided reports wizard | 
        
          | 3 | [% IF ( saved1 ) %]› Saved Reports | 3 | [% IF ( saved1 ) %]› Saved Reports | 
        
          | 4 | [% ELSIF ( create ) %]› Create from SQL | 4 | [% ELSIF ( create ) %]› Create from SQL | 
          
            
              | 5 | [% ELSIF ( showsql ) %]› Saved Reports › SQL View | 5 | [% ELSIF ( showsql ) %]› Saved reports › SQL view | 
            
              | 6 | [% ELSIF ( execute ) %]› Saved Reports › [% name %] Report | 6 | [% ELSIF ( execute ) %]› Saved reports › [% name %] Report | 
            
              | 7 | [% ELSIF ( buildx ) %]› Build A Report, Step [% buildx %] of 6: | 7 | [% ELSIF ( buildx ) %]› Build a report, step [% buildx %] of 6: | 
            
              | 8 | [% IF ( build1 ) %]Choose a Module | 8 | [% IF ( build1 ) %]Choose a module | 
            
              | 9 | [% ELSIF ( build2 ) %]Pick a Report Type | 9 | [% ELSIF ( build2 ) %]Pick a report type | 
            
              | 10 | [% ELSIF ( build3 ) %]Select Columns for Display | 10 | [% ELSIF ( build3 ) %]Select columns for display | 
            
              | 11 | [% ELSIF ( build4 ) %]Select Criteria to Limit on | 11 | [% ELSIF ( build4 ) %]Select criteria to limit on | 
        
          | 12 | [% ELSIF ( build5 ) %]Pick which columns to total | 12 | [% ELSIF ( build5 ) %]Pick which columns to total | 
        
          | 13 | [% ELSIF ( build6 ) %]Select how you want the report ordered | 13 | [% ELSIF ( build6 ) %]Select how you want the report ordered | 
        
          | 14 | [% END %] | 14 | [% END %] | 
  
    | Lines 66-82
          $(document).ready(function(){
      
      
        Link Here | 
        
          | 66 |  | 66 |  | 
        
          | 67 | <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> | 67 | <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> | 
        
          | 68 | › <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> | 68 | › <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> | 
          
            
              | 69 | › <a href="/cgi-bin/koha/reports/guided_reports.pl">Guided Reports Wizard</a> | 69 | › <a href="/cgi-bin/koha/reports/guided_reports.pl">Guided reports wizard</a> | 
        
          | 70 | ›  | 70 | ›  | 
          
            
              | 71 | [% IF ( saved1 ) %]Saved Reports | 71 | [% IF ( saved1 ) %]Saved reports | 
        
          | 72 | [% ELSIF ( create ) %]Create from SQL | 72 | [% ELSIF ( create ) %]Create from SQL | 
          
            
              | 73 | [% ELSIF ( showsql ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved Reports</a> › SQL View | 73 | [% ELSIF ( showsql ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved reports</a> › SQL view | 
            
              | 74 | [% ELSIF ( execute ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved Reports</a> › <em>[% name %]</em> Report | 74 | [% ELSIF ( execute ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved reports</a> › <em>[% name %]</em> Report | 
            
              | 75 | [% ELSIF ( buildx ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build A Report</a> › Step [% buildx %] of 6: | 75 | [% ELSIF ( buildx ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build a report</a> › Step [% buildx %] of 6: | 
            
              | 76 |     [% IF ( build1 ) %]Choose a Module | 76 |     [% IF ( build1 ) %]Choose a module | 
            
              | 77 |     [% ELSIF ( build2 ) %]Pick a Report Type | 77 |     [% ELSIF ( build2 ) %]Pick a report type | 
            
              | 78 |     [% ELSIF ( build3 ) %]Select Columns for Display | 78 |     [% ELSIF ( build3 ) %]Select columns for display | 
            
              | 79 |     [% ELSIF ( build4 ) %]Select Criteria to Limit on | 79 |     [% ELSIF ( build4 ) %]Select criteria to limit on | 
        
          | 80 |     [% ELSIF ( build5 ) %]Pick which columns to total | 80 |     [% ELSIF ( build5 ) %]Pick which columns to total | 
        
          | 81 |     [% ELSIF ( build6 ) %]Select how you want the report ordered | 81 |     [% ELSIF ( build6 ) %]Select how you want the report ordered | 
        
          | 82 |     [% END %] | 82 |     [% END %] | 
  
    | Lines 90-101
          $(document).ready(function(){
      
      
        Link Here | 
        
          | 90 |     [% INCLUDE "reports-toolbar.inc" %] | 90 |     [% INCLUDE "reports-toolbar.inc" %] | 
        
          | 91 |  | 91 |  | 
        
          | 92 | [% IF ( start ) %] | 92 | [% IF ( start ) %] | 
          
            
              | 93 |     <h2>Guided Reports</h2> | 93 |     <h2>Guided reports</h2> | 
        
          | 94 |     <p>Use the guided reports engine to create non standard reports. | 94 |     <p>Use the guided reports engine to create non standard reports. | 
        
          | 95 | This feature aims to provide some middle ground between the built in | 95 | This feature aims to provide some middle ground between the built in | 
        
          | 96 | canned reports and writing custom SQL reports.</p> | 96 | canned reports and writing custom SQL reports.</p> | 
        
          | 97 |  | 97 |  | 
          
            
              | 98 |     <h3>Build And Run Reports</h3> | 98 |     <h3>Build and run reports</h3> | 
        
          | 99 |         [% IF ( CAN_user_reports_create_reports ) %] | 99 |         [% IF ( CAN_user_reports_create_reports ) %] | 
        
          | 100 |         <form action="/cgi-bin/koha/reports/guided_reports.pl"> | 100 |         <form action="/cgi-bin/koha/reports/guided_reports.pl"> | 
        
          | 101 |             <input type="hidden" name="phase" value="Build new" /> | 101 |             <input type="hidden" name="phase" value="Build new" /> | 
  
    | Lines 117-129
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 117 | <h3>Reports Dictionary</h3> | 117 | <h3>Reports Dictionary</h3> | 
        
          | 118 | <p>Use the reports dictionary to define custom criteria to use in your reports</p> | 118 | <p>Use the reports dictionary to define custom criteria to use in your reports</p> | 
        
          | 119 | <form action="/cgi-bin/koha/reports/dictionary.pl"> | 119 | <form action="/cgi-bin/koha/reports/dictionary.pl"> | 
          
            
              | 120 | <input type="hidden" name="phase" value="View Dictionary"/> | 120 | <input type="hidden" name="phase" value="View dictionary"/> | 
            
              | 121 | <input type="submit" name="submit" value="View Dictionary"/> | 121 | <input type="submit" name="submit" value="View dictionary"/> | 
        
          | 122 | </form> | 122 | </form> | 
        
          | 123 | [% END %] | 123 | [% END %] | 
        
          | 124 |  | 124 |  | 
        
          | 125 | [% IF ( saved1 ) %] | 125 | [% IF ( saved1 ) %] | 
          
            
              | 126 | [% IF ( savedreports ) %]<h1>Saved Reports</h1> | 126 | [% IF ( savedreports ) %]<h1>Saved reports</h1> | 
        
          | 127 |  | 127 |  | 
        
          | 128 | <div id="pagertable_reports"> | 128 | <div id="pagertable_reports"> | 
        
          | 129 | [% INCLUDE 'table-pager.inc' perpage='20' %] | 129 | [% INCLUDE 'table-pager.inc' perpage='20' %] | 
  
    | Lines 133-144
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 133 | <thead> | 133 | <thead> | 
        
          | 134 |  <tr> | 134 |  <tr> | 
        
          | 135 |   <th>ID</th> | 135 |   <th>ID</th> | 
          
            
              | 136 |   <th>Report Name</th> | 136 |   <th>Report name</th> | 
        
          | 137 |   <th>Type</th> | 137 |   <th>Type</th> | 
        
          | 138 |   <th>Notes</th> | 138 |   <th>Notes</th> | 
        
          | 139 |   <th>Author</th> | 139 |   <th>Author</th> | 
          
            
              | 140 |   <th>Creation Date</th> | 140 |   <th>Creation date</th> | 
            
              | 141 |   <th>Saved Results</th> | 141 |   <th>Saved results</th> | 
        
          | 142 |   <th>Saved SQL</th> | 142 |   <th>Saved SQL</th> | 
        
          | 143 |   <th> </th> | 143 |   <th> </th> | 
        
          | 144 |   <th> </th> | 144 |   <th> </th> | 
  
    | Lines 199-208
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 199 |  | 199 |  | 
        
          | 200 |  | 200 |  | 
        
          | 201 | [% IF ( build1 ) %] | 201 | [% IF ( build1 ) %] | 
          
            
              | 202 | <h1>Build A Report</h1> | 202 | <h1>Build a report</h1> | 
        
          | 203 | <form action="/cgi-bin/koha/reports/guided_reports.pl"> | 203 | <form action="/cgi-bin/koha/reports/guided_reports.pl"> | 
        
          | 204 | <fieldset class="rows"> | 204 | <fieldset class="rows"> | 
          
            
              | 205 | <legend>Step 1 of 6: Choose a Module to Report on</legend> | 205 | <legend>Step 1 of 6: Choose a module to report on</legend> | 
        
          | 206 | <ol><li><label for="areas">Choose: </label><select name="areas" id="areas"> | 206 | <ol><li><label for="areas">Choose: </label><select name="areas" id="areas"> | 
        
          | 207 | [% FOREACH area IN areas %] | 207 | [% FOREACH area IN areas %] | 
        
          | 208 | <option value="[% area.id %]">[% area.name %]</option> | 208 | <option value="[% area.id %]">[% area.name %]</option> | 
  
    | Lines 222-228
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 222 | <h1>Build A Report</h1> | 222 | <h1>Build A Report</h1> | 
        
          | 223 | <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> | 223 | <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> | 
        
          | 224 | <input type="hidden" name="area" value="[% area %]" /> | 224 | <input type="hidden" name="area" value="[% area %]" /> | 
          
            
              | 225 | <fieldset class="rows"><legend>Step 2 of 6: Pick a Report Type</legend> | 225 | <fieldset class="rows"><legend>Step 2 of 6: Pick a report type</legend> | 
        
          | 226 | <ol><li><label for="types">Choose: </label> | 226 | <ol><li><label for="types">Choose: </label> | 
        
          | 227 |     <select id="types" name="types"> | 227 |     <select id="types" name="types"> | 
        
          | 228 |         <option value="1">Tabular</option> | 228 |         <option value="1">Tabular</option> | 
  
    | Lines 249-255
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 249 | [% END %] | 249 | [% END %] | 
        
          | 250 |  | 250 |  | 
        
          | 251 | [% IF ( build3 ) %] | 251 | [% IF ( build3 ) %] | 
          
            
              | 252 | <h3>Step 3 of 6: Select Columns for Display</h3> | 252 | <h3>Step 3 of 6: Select columns for display</h3> | 
        
          | 253 | <p>Note: Be careful selecting when selecting columns. If your choice is too broad it could result in a very large report that will either not complete, or slow your system down.</p> | 253 | <p>Note: Be careful selecting when selecting columns. If your choice is too broad it could result in a very large report that will either not complete, or slow your system down.</p> | 
        
          | 254 |  | 254 |  | 
        
          | 255 | <form id="column_submit" action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> | 255 | <form id="column_submit" action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> | 
  
    | Lines 303-309
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 303 |     <input type="hidden" name="area" value="[% area %]" /> | 303 |     <input type="hidden" name="area" value="[% area %]" /> | 
        
          | 304 |     <input type="hidden" name="type" value="[% type %]" /> | 304 |     <input type="hidden" name="type" value="[% type %]" /> | 
        
          | 305 |     <input type="hidden" name="column" value="[% column %]" /> | 305 |     <input type="hidden" name="column" value="[% column %]" /> | 
          
            
              | 306 |     <fieldset><legend>Step 4 of 6: Select Criteria to Limit on</legend> | 306 |     <fieldset><legend>Step 4 of 6: Select criteria to limit on</legend> | 
        
          | 307 |     <table> | 307 |     <table> | 
        
          | 308 |         [% FOREACH criteri IN criteria %] | 308 |         [% FOREACH criteri IN criteria %] | 
        
          | 309 |         <tr> | 309 |         <tr> | 
  
    | Lines 314-320
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 314 |         [% IF ( criteri.date ) %] | 314 |         [% IF ( criteri.date ) %] | 
        
          | 315 |         <td> | 315 |         <td> | 
        
          | 316 |             <input type="text" size="10" id="[% criteri.name %]_value" name="[% criteri.name %]_value" value="" /> | 316 |             <input type="text" size="10" id="[% criteri.name %]_value" name="[% criteri.name %]_value" value="" /> | 
          
            
              | 317 |             <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfrom[% criteri.name %]" style="cursor: pointer;" alt="Show Calendar" title="Show Calendar" />                  | 317 |             <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfrom[% criteri.name %]" style="cursor: pointer;" alt="Show calendar" title="Show calendar" /> | 
        
          | 318 |             <script type="text/javascript">    | 318 |             <script type="text/javascript">    | 
        
          | 319 |             Calendar.setup({   | 319 |             Calendar.setup({   | 
        
          | 320 |             inputField     : "[% criteri.name %]_value", | 320 |             inputField     : "[% criteri.name %]_value", | 
  
    | Lines 337-343
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 337 |             [% IF ( criteri.daterange ) %] | 337 |             [% IF ( criteri.daterange ) %] | 
        
          | 338 |             <td>from  | 338 |             <td>from  | 
        
          | 339 |             <input type="text" size="10" id="from_[% criteri.name %]_value" name="from_[% criteri.name %]_value" value="" /> | 339 |             <input type="text" size="10" id="from_[% criteri.name %]_value" name="from_[% criteri.name %]_value" value="" /> | 
          
            
              | 340 |             <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfromfrom_[% criteri.name %]" style="cursor: pointer;" alt="Show Calendar" title="Show Calendar" />                  | 340 |             <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfromfrom_[% criteri.name %]" style="cursor: pointer;" alt="Show calendar" title="Show calendar" /> | 
        
          | 341 |             <script type="text/javascript">    | 341 |             <script type="text/javascript">    | 
        
          | 342 |                 Calendar.setup({   | 342 |                 Calendar.setup({   | 
        
          | 343 |                 inputField     : "from_[% criteri.name %]_value", | 343 |                 inputField     : "from_[% criteri.name %]_value", | 
  
    | Lines 348-354
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 348 |             </script>          | 348 |             </script>          | 
        
          | 349 |             to | 349 |             to | 
        
          | 350 |             <input type="text" size="10" id="to_[% criteri.name %]_value" name="to_[% criteri.name %]_value" value="" /> | 350 |             <input type="text" size="10" id="to_[% criteri.name %]_value" name="to_[% criteri.name %]_value" value="" /> | 
          
            
              | 351 |             <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfromto_[% criteri.name %]" style="cursor: pointer;" alt="Show Calendar" title="Show Calendar" />                  | 351 |             <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfromto_[% criteri.name %]" style="cursor: pointer;" alt="Show calendar" title="Show calendar" /> | 
        
          | 352 |             <script type="text/javascript">    | 352 |             <script type="text/javascript">    | 
        
          | 353 |                 Calendar.setup({   | 353 |                 Calendar.setup({   | 
        
          | 354 |                 inputField     : "to_[% criteri.name %]_value", | 354 |                 inputField     : "to_[% criteri.name %]_value", | 
  
    | Lines 377-383
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 377 |     </fieldset> | 377 |     </fieldset> | 
        
          | 378 |  | 378 |  | 
        
          | 379 | [% IF ( definitions ) %] | 379 | [% IF ( definitions ) %] | 
          
            
              | 380 | <fieldset><legend>Dictionary Definitions</legend><table> | 380 | <fieldset><legend>Dictionary definitions</legend><table> | 
        
          | 381 | [% FOREACH definition IN definitions %] | 381 | [% FOREACH definition IN definitions %] | 
        
          | 382 |     <tr><td><input type="checkbox" name="definition" value="[% definition.id %]" /> [% definition.name %]</td></tr> | 382 |     <tr><td><input type="checkbox" name="definition" value="[% definition.id %]" /> [% definition.name %]</td></tr> | 
        
          | 383 | [% END %] | 383 | [% END %] | 
  
    | Lines 413-419
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 413 | [% END %] | 413 | [% END %] | 
        
          | 414 | </table></fieldset> | 414 | </table></fieldset> | 
        
          | 415 |  | 415 |  | 
          
            
              | 416 | <fieldset class="action"><input type="hidden" name="phase" value="Choose These Operations" /> | 416 | <fieldset class="action"><input type="hidden" name="phase" value="Choose these operations" /> | 
        
          | 417 |     <input type="button" name="back" value="<< Back" onclick="javascript:history.back()" /> | 417 |     <input type="button" name="back" value="<< Back" onclick="javascript:history.back()" /> | 
        
          | 418 |     <input type="submit" name="submit" value="Next >>" /></fieldset> | 418 |     <input type="submit" name="submit" value="Next >>" /></fieldset> | 
        
          | 419 | </form> | 419 | </form> | 
  
    | Lines 443-456
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 443 | </table></fieldset> | 443 | </table></fieldset> | 
        
          | 444 |  | 444 |  | 
        
          | 445 | <fieldset class="action"> | 445 | <fieldset class="action"> | 
          
            
              | 446 | <input type="hidden" name="phase" value="Build Report" /> | 446 | <input type="hidden" name="phase" value="Build report" /> | 
        
          | 447 | <input type="submit" name="submit" value="Finish" /></fieldset> | 447 | <input type="submit" name="submit" value="Finish" /></fieldset> | 
        
          | 448 | </form> | 448 | </form> | 
        
          | 449 | [% END %] | 449 | [% END %] | 
        
          | 450 |  | 450 |  | 
        
          | 451 |  | 451 |  | 
        
          | 452 | [% IF ( showreport ) %] | 452 | [% IF ( showreport ) %] | 
          
            
              | 453 | <h1>Confirm Custom Report</h1> | 453 | <h1>Confirm custom report</h1> | 
        
          | 454 | <p>Your report will be generated with the following SQL statement.</p> | 454 | <p>Your report will be generated with the following SQL statement.</p> | 
        
          | 455 | <p>  | 455 | <p>  | 
        
          | 456 | [% sql |html %] | 456 | [% sql |html %] | 
  
    | Lines 470-482
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 470 | <input type="hidden" name="sql" value="[% sql |html %]" /> | 470 | <input type="hidden" name="sql" value="[% sql |html %]" /> | 
        
          | 471 | <input type="hidden" name="type" value="[% type %]" /> | 471 | <input type="hidden" name="type" value="[% type %]" /> | 
        
          | 472 | <fieldset class="rows"> | 472 | <fieldset class="rows"> | 
          
            
              | 473 | <legend>Save Your Custom Report</legend> | 473 | <legend>Save your custom report</legend> | 
        
          | 474 | <ol> | 474 | <ol> | 
          
            
              | 475 |     <li><label for="reportname">Report Name: </label><input type="text" id="reportname" name="reportname" /></li> | 475 |     <li><label for="reportname">Report name: </label><input type="text" id="reportname" name="reportname" /></li> | 
        
          | 476 |     <li><label for="notes">Notes:</label> <textarea name="notes" id="notes"></textarea></li> | 476 |     <li><label for="notes">Notes:</label> <textarea name="notes" id="notes"></textarea></li> | 
        
          | 477 | </ol></fieldset> | 477 | </ol></fieldset> | 
          
            
              | 478 | <fieldset class="action"><input type="hidden" name="phase" value="Save Report" /> | 478 | <fieldset class="action"><input type="hidden" name="phase" value="Save report" /> | 
            
              | 479 | <input type="submit" name="submit" value="Save Report" /></fieldset> | 479 | <input type="submit" name="submit" value="Save report" /></fieldset> | 
        
          | 480 | </form> | 480 | </form> | 
        
          | 481 | [% END %] | 481 | [% END %] | 
        
          | 482 |  | 482 |  | 
  
    | Lines 490-496
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 490 |             [% IF sql_param.input == 'date' %] | 490 |             [% IF sql_param.input == 'date' %] | 
        
          | 491 |                 <p> | 491 |                 <p> | 
        
          | 492 |                 [% sql_param.entry %]: <input id="date_[% sql_param_entry %]" type="text" value="" size="10" name="sql_params"> | 492 |                 [% sql_param.entry %]: <input id="date_[% sql_param_entry %]" type="text" value="" size="10" name="sql_params"> | 
          
            
              | 493 |                 <img id="date_picker_[% sql_param_entry %]" alt="Show Calendar" src="/intranet-tmpl/prog/en/lib/calendar/cal.gif"> | 493 |                 <img id="date_picker_[% sql_param_entry %]" alt="Show calendar" src="/intranet-tmpl/prog/en/lib/calendar/cal.gif"> | 
        
          | 494 |                 <script type="text/javascript"> | 494 |                 <script type="text/javascript"> | 
        
          | 495 |                       Calendar.setup( { | 495 |                       Calendar.setup( { | 
        
          | 496 |                          inputField : "date_[% sql_param_entry %]", | 496 |                          inputField : "date_[% sql_param_entry %]", | 
  
    | Lines 526-533
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 526 | <fieldset class="action"> | 526 | <fieldset class="action"> | 
        
          | 527 | <label for="format">Download the report: </label> | 527 | <label for="format">Download the report: </label> | 
        
          | 528 | <select name="format" id="format"> | 528 | <select name="format" id="format"> | 
          
            
              | 529 | <option value="csv">Comma Separated Text</option> | 529 | <option value="csv">Comma separated text</option> | 
            
              | 530 | <option value="tab">Tab Separated Text</option> | 530 | <option value="tab">Tab separated text</option> | 
        
          | 531 | </select> | 531 | </select> | 
        
          | 532 | <input type="hidden" name="sql" value="[% sql |html %]" /> | 532 | <input type="hidden" name="sql" value="[% sql |html %]" /> | 
        
          | 533 | <input type="hidden" name="phase" value="Export" /> | 533 | <input type="hidden" name="phase" value="Export" /> | 
  
    | Lines 539-547
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 539 | [% IF ( create ) %] | 539 | [% IF ( create ) %] | 
        
          | 540 | <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> | 540 | <form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> | 
        
          | 541 | <fieldset class="rows"> | 541 | <fieldset class="rows"> | 
          
            
              | 542 | <legend>Create Report From SQL</legend> | 542 | <legend>Create report from SQL</legend> | 
        
          | 543 | <ol> | 543 | <ol> | 
          
            
              | 544 |     <li><label for="reportname">Report Name:</label>  | 544 |     <li><label for="reportname">Report name:</label> | 
        
          | 545 |         [% IF ( reportname ) %]<input type="text" id="reportname" name="reportname" value="[% reportname %]" /> | 545 |         [% IF ( reportname ) %]<input type="text" id="reportname" name="reportname" value="[% reportname %]" /> | 
        
          | 546 |         [% ELSE %]<input type="text" id="reportname" name="reportname" />[% END %]  | 546 |         [% ELSE %]<input type="text" id="reportname" name="reportname" />[% END %]  | 
        
          | 547 |     </li> | 547 |     </li> | 
  
    | Lines 562-568
          canned reports and writing custom SQL reports.</p>
      
      
        Link Here | 
        
          | 562 | </div> | 562 | </div> | 
        
          | 563 | </fieldset> | 563 | </fieldset> | 
        
          | 564 |  | 564 |  | 
          
            
              | 565 | <fieldset class="action"><input type="hidden" name="phase" value="Save Report" /> | 565 | <fieldset class="action"><input type="hidden" name="phase" value="Save report" /> | 
        
          | 566 | <input type="submit" name="submit" value="Save Report" /> <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved" class="cancel">Cancel</a> | 566 | <input type="submit" name="submit" value="Save Report" /> <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved" class="cancel">Cancel</a> | 
        
          | 567 | </fieldset> | 567 | </fieldset> | 
        
          | 568 | </form> | 568 | </form> | 
  
    | Lines 582-589
          Sub report:<select name="subreport">
      
      
        Link Here | 
        
          | 582 | [% END %] | 582 | [% END %] | 
        
          | 583 | </select> | 583 | </select> | 
        
          | 584 | <br /> | 584 | <br /> | 
          
            
              | 585 | <input type="hidden" name="phase" value="Save Compound" /> | 585 | <input type="hidden" name="phase" value="Save compound" /> | 
            
              | 586 | <input type="submit" name="submit" value="Save Compound" /> | 586 | <input type="submit" name="submit" value="Save compound" /> | 
        
          | 587 | </form> | 587 | </form> | 
        
          | 588 | [% END %] | 588 | [% END %] | 
        
          | 589 |  | 589 |  | 
  
    | Lines 594-600
          Sub report:<select name="subreport">
      
      
        Link Here | 
        
          | 594 |  | 594 |  | 
        
          | 595 |  | 595 |  | 
        
          | 596 | [% IF ( retresults ) %] | 596 | [% IF ( retresults ) %] | 
          
            
              | 597 | <h1>Saved Report Results</h1> | 597 | <h1>Saved report results</h1> | 
        
          | 598 | <h2>[% name %]</h2> | 598 | <h2>[% name %]</h2> | 
        
          | 599 | <p>[% notes %]</p> | 599 | <p>[% notes %]</p> | 
        
          | 600 | <table> | 600 | <table> | 
  
    | Lines 621-627
          Sub report:<select name="subreport">
      
      
        Link Here | 
        
          | 621 | <fieldset class="rows"> | 621 | <fieldset class="rows"> | 
        
          | 622 | <legend>Edit SQL report</legend> | 622 | <legend>Edit SQL report</legend> | 
        
          | 623 | <ol> | 623 | <ol> | 
          
            
              | 624 | <li><label for="reportname">Report Name:</label><input type="text" id="reportname" name="reportname" value="[% reportname %]" size="50" /></li> | 624 | <li><label for="reportname">Report name:</label><input type="text" id="reportname" name="reportname" value="[% reportname %]" size="50" /></li> | 
        
          | 625 | <li><label for="notes">Notes:</label><textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li> | 625 | <li><label for="notes">Notes:</label><textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li> | 
        
          | 626 | <li><textarea id="sql" name="sql" rows="10" cols="60">[% sql %]</textarea></li> | 626 | <li><textarea id="sql" name="sql" rows="10" cols="60">[% sql %]</textarea></li> | 
        
          | 627 | </ol> | 627 | </ol> | 
  
    | Lines 643-651
          Sub report:<select name="subreport">
      
      
        Link Here | 
        
          | 643 |     [% IF ( id ) %] | 643 |     [% IF ( id ) %] | 
        
          | 644 |     <li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% id %]&phase=Run%20this%20report">Run this report</a></li> | 644 |     <li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% id %]&phase=Run%20this%20report">Run this report</a></li> | 
        
          | 645 |     [% END %] | 645 |     [% END %] | 
          
            
              | 646 |     <li>Access this report from the: <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved Reports Page</a></li> | 646 |     <li>Access this report from the: <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved reports page</a></li> | 
            
              | 647 |     <li>Schedule this report to run using the: <a href="/cgi-bin/koha/tools/scheduler.pl">Scheduler Tool</a></li> | 647 |     <li>Schedule this report to run using the: <a href="/cgi-bin/koha/tools/scheduler.pl">Scheduler tool</a></li> | 
            
              | 648 |     <li>Return to: <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Guided Reports</a></li> | 648 |     <li>Return to: <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Guided reports</a></li> | 
        
          | 649 | </ul> | 649 | </ul> | 
        
          | 650 | [% END %] | 650 | [% END %] | 
        
          | 651 | [% END %] | 651 | [% END %] | 
  
    | Lines 664-670
          Sub report:<select name="subreport">
      
      
        Link Here | 
        
          | 664 | [% END %] | 664 | [% END %] | 
        
          | 665 | </div> | 665 | </div> | 
        
          | 666 | <fieldset class="action"><input type="hidden" name="phase" value="Use saved" /> | 666 | <fieldset class="action"><input type="hidden" name="phase" value="Use saved" /> | 
          
            
              | 667 | <input type="submit" name="submit" value="Saved Reports" /></fieldset> | 667 | <input type="submit" name="submit" value="Saved reports" /></fieldset> | 
        
          | 668 | </form> | 668 | </form> | 
        
          | 669 | [% END %] | 669 | [% END %] | 
        
          | 670 |  | 670 |  | 
  
    | Lines 681-687
          Sub report:<select name="subreport">
      
      
        Link Here | 
        
          | 681 |   <h3>Filter</h3> | 681 |   <h3>Filter</h3> | 
        
          | 682 |   <ol> | 682 |   <ol> | 
        
          | 683 |     <li><label for="filter_date">Date: | 683 |     <li><label for="filter_date">Date: | 
          
            
              | 684 |   <img src="[% themelang %]/lib/calendar/cal.gif" id="datedueto_button" alt="Show Calendar" /></label> <input type="text" id="filter_date" name="filter_date" size="10" value="[% filter_date %]" /> | 684 |   <img src="[% themelang %]/lib/calendar/cal.gif" id="datedueto_button" alt="Show calendar" /></label> <input type="text" id="filter_date" name="filter_date" size="10" value="[% filter_date %]" /> | 
        
          | 685 |     <div class="hint">[% INCLUDE 'date-format.inc' %]</div> | 685 |     <div class="hint">[% INCLUDE 'date-format.inc' %]</div> | 
        
          | 686 |     <script type="text/javascript"> | 686 |     <script type="text/javascript"> | 
        
          | 687 |         Calendar.setup( | 687 |         Calendar.setup( |