Re: Oracle Report 2.0

In article <40h8vb$3gs_at_guillotine.mtl.dmr.ca> Bernard Drolet <Bernard.Drolet_at_dmr.ca> writes:

> I am presently writing a report with Oracle Report V2.0.
>
> My report is simply a letter containing a bill, and is not so complex. The
> problem is that the architects decided, in the analysis that there must be one
> specific file written in a Unix system for each of the customer.
>
> They decided of a specific way of naming each one, build on date and customer
> number.
>
> Is there a way I can force Oracle Report to close the initial output file, open
> a new one, write a page in it, close it, open a new one and so on?
>
> Presently the only way I founded is by writing a Pro*C executable that will call
> r20run on the Unix system, once for each customer, or even an other Report, with a
> filter forcing to run again r20run for each customer.
>
> Loading a couple hundred time the Oracle Report software, loading my report
> definition, firing it is really time consuming.
>
> Do anyone have a better idea (as simply changing output file on the run?)

This isn't an elegant solution but maybe this may work:

Write a report that outputs the report contents as well as file name information to a pipe. Have a separate program that reads from the pipe and directs the output to separate files with specified file names. You probably can do a fork() and exec() to spawn the OR process.

--
 Alvin W. Law ........................................... Oracle Corporation
 Project Leader ............................. 300 Oracle Parkway, Box 659305
 Applications Design & Architecture ............... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ...... Voice: +1.415.506.8317 . Fax: +1.415.506.7294

******************************** W a r n i n g ******************************
Microsoft Network is prohibited from redistributing this work in any form, in
whole or in part, without the express written consent of the original author.