Re: Populate page(report) from oracle database

"Mark" <joystar.jin_at_gmail.com> wrote in message news:1106061776.513798.115640_at_c13g2000cwb.googlegroups.com...
> 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
>

as i recall, you can do the same exact thing with an ODBC connection to oracle -- but i think you need Oracle Net installed on your machine

other possibilities are excel report output via HTMLDB or oracle reports

++ mcs Received on Tue Jan 18 2005 - 09:27:47 CST