Re: Creating and printing reports

In article <1ec288ef.0107050704.75205b9c_at_posting.google.com>,

        laufrech_at_aol.com (Laurent) writes:

> I have simple questions about creating reports using SQL Report or
> something of this kind (may be the product changed of name since I had
> a look years ago ;-)

The current equivalent of SQL*Reportwriter is Oracle Reports and yes, it's changed a lot! There are also other ways of building reports these days, e.g. PL/SQL module in IAS, Java servlets, PSPs producing HTML/CSS or even XML/CSS output.

> I'd like to know if it is possible to print reports on demand from a
> Java application first, and also if I can print report using batch
> (using an application scheduler like... cron).

With Oracle Reports, you will create a report file and run the report locally using Oracle Reports runtime (rwrun60) or submit it to a remote Reports Server (rwcli60). Calling these tools from a Java application is very simple, e.g. using java.lang.Runtime, and scheduling using cron is equally straightforward. You can also print/email/create files to multiple destinations using distribution files with Oracle Reports.

-- 
Regards,

Richard Senior
Mill Dam Consulting Limited
London