[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 479
  • Last Modified:

Oracle Reports create ad hoc reports

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
dbfromnewjersey
Asked:
dbfromnewjersey
  • 2
1 Solution
 
dbfromnewjerseyAuthor Commented:
will read.
0
 
Mark GeerlingsDatabase AdministratorCommented:
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
 
dbfromnewjerseyAuthor Commented:
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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now