|
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> |