Re: sqlreportwriter

In article <25iqqv$elg_at_hsc.usc.edu>, mcitron_at_hsc.usc.edu (Mark Citron) writes:
> Is there a way for reportwriter to access an ascii file to be included
> in the report.
>
> We need to have some info printed at the bottom of the
> page. This info is constantly changing and it would be ideal if a user
> could simply change a text file instead of learning how to
> rebuild the entire report.
>
> Any suggestions would be appreciated
>
> Mark Citron
> Childrens Hospital Los Angeles
>
> --
> Mark Citron
> mark_at_neurosci.usc.edu
>

build your variable text statement into an Oracle table with appropriate forms, etc needed to keep it current. Include in the reportwriter routine a footer section that reads this table and incorportes into the final document.

 | Frank Greene DELPHI SYSTEMS Inc    |          _/_/_/  _/_/_/             |
 | Telephone [615] 458-6032           |           _/_/    _/_/              |
 | Internet 74200.427_at_compuserve.com  |          _/_/    _/_/  _/_/_/       |
 | Compuserve 74200,427               |         _/_/    _/_/    _/_/        |
 | 324 Ootsima Way                    |        _/_/    _/_/    _/_/         |
 | Loudon, TN 37774                   |       _/_/_/  _/_/_/  _/_/_/        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------