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

Dear all,

One more question for reporting, in the process of getting the result, SQL*Plus will stop responding to any user interaction. For complicated reports, it may take from minutes to hours to get the result, it is much better if the program can show a progress bar to inform the user of the approximate time needed to complete the job.

Thanks again.
Dino

Dino Hsu <dino1_at_ms1.hinet.net> wrote in message news:8mgv6i$6hhq5$1_at_ID-41926.news.cis.dfn.de...
> 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
>
>
>
>
Received on Sun Aug 06 2000 - 00:00:00 CDT