Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating and printing reports

Re: Creating and printing reports

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sun, 8 Jul 2001 17:16:37 +0100
Message-ID: <9ia0t9$20$1@plutonium.btinternet.com>

Thought you may be interested to read about SQL*XL. SQL*XL is an addin for Excel that specialises in getting data into Excel hassle free. You can use it perfectly for reporting and it can be setup with relative easy to make it run batches.

For a start SQL*XL can execute multiple select statements at a time and you can specify with each statement where the data should go on the spreadsheet. Furthermore, SQL*XL supports macro recording and you can program the commands yourself. The API is specified in the help file along with some examples.

When you write your Java app to open a spreadsheet it can use the SQL*XL addin as well.

Have a look at SQL*XL at www.oraxcel.com

Hope this helps,

--
Gerrit-Jan Linker
SQL*XL: addin for Excel for easy access to Oracle databases
http://www.oraxcel.com


"Laurent" <laufrech_at_aol.com> wrote in message
news:1ec288ef.0107050704.75205b9c_at_posting.google.com...

> Hello,
>
> 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 ;-)
>
> 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).
>
> Thanks in advance.
>
> L. Aufrechter
Received on Sun Jul 08 2001 - 11:16:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US