Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Populate page(report) from oracle database

Re: Populate page(report) from oracle database

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 18 Jan 2005 10:41:48 -0500
Message-ID: <BOidnUP-D_ygs3DcRVn-3A@comcast.com>

"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?

++ mcs Received on Tue Jan 18 2005 - 09:41:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US