Re: What's the best reporting tool for ad-hoc and custom-made reporting

Hi,

My product SQL*XL may be of help to you. SQL*XL LITE is free and allows you to connect to Oracle from Excel and fetch data straight into spreadsheets. This way you can skip the import to Excel process.

Have a look at SQL*XL at http://www.oraxcel.com

Hope you like it.

Gerrit-Jan Linker

In article <8mgv6i$6hhq5$1_at_ID-41926.news.cis.dfn.de>,   "Dino Hsu" <dino1_at_ms1.hinet.net> wrote:
> Dear all,
>
> We are using Oracle 8.0.5 for Windows NT. I know SQL*Plus and a
 little bit
> PL/SQL, for ad-hoc reporting, I can write a script something like
 this:
>
> set pagesize 10000;
> spool listdate;
> select to_char(invoice_date,'yyyymmdd') inv_date,
> to_char(process_date,'yyyymmdd') proc_date,
> count(*) rec_cnt, sum(units) unit_sum from tb_orders
> group by invoice_date, process_date;
> spool off;
> quit;
>
> Furthermore, I need to get the group totals and the grand total, so I
 import
> his result into Excel or Access for the calculation, which is quite
 tedious.
> I think I need a good reporting tool for this.
>
> I also found in the case of PL/SQL that Oracle provided tool is not
 the
> best, maybe 3rd party tool such as SQL Station or TOAD are the best.
 Can
> anyone commet on the best reporting tool for ad-hos and custom-made
> reporting requirements?
>
> Thanks in advance.
> Dino
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Sep 02 2000 - 16:54:42 CDT