Lines 486-492
canned reports and writing custom SQL reports.</p>
Link Here
|
486 |
<h1>Enter parameters for report [% name %]:</h1> |
486 |
<h1>Enter parameters for report [% name %]:</h1> |
487 |
[% IF ( notes ) %]<p>[% notes %]</p>[% END %] |
487 |
[% IF ( notes ) %]<p>[% notes %]</p>[% END %] |
488 |
[% FOREACH sql_param IN sql_params %] |
488 |
[% FOREACH sql_param IN sql_params %] |
489 |
<p>[% sql_param.entry %]: [% sql_param.input %]</p> |
489 |
[% IF sql_param.input == 'date' %] |
|
|
490 |
<p> |
491 |
[% sql_param.entry %]: <input id="date_[% sql_param_entry %]" type="text" value="" size="10" name="sql_params"> |
492 |
<img id="date_picker_[% sql_param_entry %]" alt="Show Calendar" src="/intranet-tmpl/prog/en/lib/calendar/cal.gif"> |
493 |
<script type="text/javascript"> |
494 |
Calendar.setup( { |
495 |
inputField : "date_[% sql_param_entry %]", |
496 |
ifFormat : "%Y-%m-%d", |
497 |
button : "date_picker_[% sql_param_entry %]" |
498 |
} ); |
499 |
</script> |
500 |
</p> |
501 |
[% ELSE %] |
502 |
<p>[% sql_param.entry %]: [% sql_param.input %]</p> |
503 |
[% END %] |
490 |
[% END %] |
504 |
[% END %] |
491 |
<input type='submit' value='Run the report'/> |
505 |
<input type='submit' value='Run the report'/> |
492 |
</form> |
506 |
</form> |