Mark C. Stock wrote:
> "Andrew Hardy" <junkmail@[127.0.0.1]> wrote in message
> news:csja6h$27s$2_at_sun-cc204.lut.ac.uk...
>
>>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?
>>
>
>
> Are you thinking PL/SQL Web Toolkit?
Yes, that's the stuff.
--
Andy
Opinions are mine and do not necessarily reflect those of Advantica
Technologies
Received on Tue Jan 18 2005 - 09:49:37 CST
