Solved

Oracle Reports create ad hoc reports

Posted on 2014-01-16
4
462 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
[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
 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to take different types of Oracle backups using RMAN.

739 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