1 Reply Latest reply on Jan 29, 2013 10:29 PM by Barry Mcgillin-Oracle

    Reporting tool database structure

      I am about to create a business intelligence tool, but I don't know how to store the created reports. I want some reports in which I have determined which tables and fields should be printed with the correct JOINS.

      Perhaps I shouldn't make it any more difficult than storing the SQL for each report. It will just make difficult to edit the report. I thought there were a smart way the most tools used.

      Does anyone have any experience in such tools?
        • 1. Re: Reporting tool database structure
          Barry Mcgillin-Oracle
          You can create a bunch of custom reports and add them in as XML extensions.
          Take a look at Jeffs pages for some decent report examples. Heres one example: http://www.thatjeffsmith.com/archive/2012/01/sweet-child-report-o-mine/

          Then, you can export them out to XML and register them in the preferences under PRefs > Database > XML Extensions.

          Restart SQLDev and you'll be able to see the reports in the report navigator under shared reports.