Solved

Oracle Reports create ad hoc reports

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
How to increase the row limit in Jasper Server.
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…
Via a live example, show how to take different types of Oracle backups using RMAN.

825 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