Solved

Oracle Reports create ad hoc reports

Posted on 2014-01-16
4
446 Views
Last Modified: 2014-01-29
Hello.

New to Oracle Reports but have SQL programming experience with other software products.

Other than having run a couple of existing reports in Oracle Reports, I haven't done anything with the product.

I'm wondering if it's possible, and if so how to navigate to it, to write customized SQL in a code window with this product.  Or, if that's not possible, to at least be able to generate customized queries with a graphical interface (selecting fields and entering search criteria, etc.)

My issue at this point is just trying to navigate through the product.  Ideally, I'd like to be able to get to an area in the product where I can view the tables, fields, relationships, etc and then write SQL code or at least generate custom queries.  

My employer has registered me as a super user if that information is of any help to you.

Thanks.
0
Comment
Question by:dbfromnewjersey
  • 2
4 Comments
 

Author Comment

by:dbfromnewjersey
ID: 39788144
will read.
0
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 500 total points
ID: 39789204
I've worked with Oracle Reports since the very first version of it.  Yes, it does allow you to use a GUI interface to "view the tables, fields, ... etc and then write SQL code or at least generate custom queries".  If you click: "Data Model", then click the "SQL" button, then "Query Builder", you can do this.

Or, you can "write customized SQL in a code window with this product" and make that the main (or a secondary) query that the report uses.

But no, Oracle Reports certainly does not support end users "creat[ing] ad hoc reports" with this tool.  This is definitely a tool for programmers or developers, not typical end users.

I have never considered Oracle Reports to be user friendly or easy to work with.  Some standard GUI features (like: "drag and drop", "copy and paste", for example) are only partially supported by Oracle Reports, or only in certain areas of the tool, not some of the areas where you might expect them to work.

The best way to work with Oracle Reports *AND* the way to get reports that perform efficiently is to develop database views that do most or all of the joining, filtering, and/or grouping that you want in the report, then write a simple query in the report to select everything from the view.

You may be aware that Oracle Reports is basically an obsolete product.  Oracle doesn't use it anymore in the latest version of their own applications.  They have switched to OBI or OBIEE (Oracle Business Intelligence Enterprise Edition).
0
 

Author Comment

by:dbfromnewjersey
ID: 39817441
Thanks.  Unfortunately, I'm stuck with having to use what my employer has in in place even though as you say, it's obsolete.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now