Solved

Oracle Discoverer Interface through ColdFusion Application

Posted on 2008-06-26
4
213 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 125 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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them (http://www.randhawaworld.com/) . I did keep the main js functions but made sever…
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…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

728 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