Mark wrote:
> My work needs to run queries on Oracle databases to generate
> report.
>
> The report here I mean, may not has the same meaning as oracle report.
> The report I mean is basically in excel format to summarize
> the database.
>
> The figure in each cell of the spreadsheet is resulted from a query
> on oracle database. There are a lot of queries need to run in order to
> get the whole spreadsheet. And the same thing needs to be repeated
> every month, by only changing the month value in the query.
>
> I am wondering is there a way to connect each query to excel
> speadsheet, and automatically generate this report?
> I did this kind of thing in Access before by using Access report.
> After setting up the access report, the whole report page can be
> generated by just one click. And the user can just key in the month
> value to get the report.
>
> Thanks,
>
> Matt
>
How about generating the report within Oracle as an HTML page with a
MIME-type for Excel?
Received on Tue Jan 18 2005 - 09:32:26 CST
