Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating and printing reports
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...Received on Sun Jul 08 2001 - 11:16:37 CDT
> 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
![]() |
![]() |