Oracle Reports

Oracle Different Report and Their Steps to Create a Report

RDF Report

      1)   Create RDF File.

      2)   Generate .XML File.

      3)   Create .RTF File by loading .XML File

      4)   Create Executables

      5)   Create concurrent program and create required value sets

      6)   Register Program into Request Group of Particular Responsibility
         from which want to run Request.

      7)   Create Data Definations

      8)   Create Data Template and upload .RTF File.

      9)   Upload .RDF File by using FTP Details.

    10)                Submit Request by running cp.

Procedure with HTML Report

1)   Create Package and Procedure with including HTML Code

2)   Create Executables

3)   Create concurrent programa and Select Format as HTMS and create required value sets

4)   Register Program into Request Group of Particular Responsibility from which want to run Request.

5)   Run the Report

Procedure with XML Report

1)   Create Package and Procedure with including XML Code

2)   Create Executables

3)   Create concurrent program and create required value sets

4)   Register Program into Request Group of Particular Responsibility from which want to run Request.

5)   Now Run Request – it shows you XML Code.

6)   Now create one .XML file by using this .XML Code

7)   Create rtf file by using this .XML File.

8)   Create Data Definations

9)   Create Data Template and upload .RTF File.

10)         Now Again Submit Request now you get .RTF File as output.

CrossTab Report (Matrix Report) By using RDF

     1)   Create RDF File.

     2)   Generate .XML File.

     3)   Create .RTF File by loading .XML File and do tagging in matrix format

     4)   Create Executables

     5)   Create concurrent program and create required value sets

     6)   Register Program into Request Group of Particular Responsibility from which        want to run Request.

     7)   Create Data Definations

     8)   Create Data Template and upload .RTF File.

     9)   Upload .RDF File by using FTP Details.

    10)  Submit Request by running cp.

or

CrossTab Report (Matrix Report) By using Procedure

You can also handle xml code into procedure and can make matrix report by using cursor and various plsql code.