?
Solved

Oracle Discoverer Interface through ColdFusion Application

Posted on 2008-06-26
4
Medium Priority
?
215 Views
Last Modified: 2013-12-20
Is it possible (reasonable) to develop a ColdFusion application which interfaces with Oracle Discoverer to build Reports?


0
Comment
Question by:lvnguyen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 19

Expert Comment

by:erikTsomik
ID: 21877526
what version of CF you using . CF 8 provide great tools for building reports
0
 
LVL 39

Expert Comment

by:gdemaria
ID: 21877596
what do you mean by "interfaces"  ?

You may be able to link to reports, but I don't think you would be able to populate oracle's tables in order to create a report without going through the discoverer GUI.

But you could use Discoverer to build reports against tables that your Coldfusion app is using...
0
 

Author Comment

by:lvnguyen
ID: 21878036
We're using ColdFusion 8.  What is desired is to be able to dynamically choose parameters through the ColdFusion app and generate Discoverer reports from those parameters, then display the reports.
0
 
LVL 39

Accepted Solution

by:
gdemaria earned 375 total points
ID: 21878413
If I recall correctly, you can create a form screen interface for discoverer reports and submitting that form would run the report.   So, if that is actually true, you could do it also from Coldfusion.

I don't really recall the Discoverer side that well, perhaps someone from the Oracle forum could add their thoughts on what Discoverer allows for running a report..

For example, can you run a report from a form submit or from a URL with paramters in the query string?  If so, you can do it from CF...

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question