Oracle Reports Basics.

Oracle Reports Basics.

Step1: Start Connecting.

• Open the Oracle Reports Builder, go to File Menu and press Connect or execute the command Ctrl+J.
• On the second step, you need to enter the user name, password and the database name.

Step2: Create Report Wizard in Oracle Reports.

Click on Reports and the press the button Create. An alert "Create a new report" with two option will appear, and here you choose: Use the Report Wizard.

Step3: Choose The Type of Layout and Style Reports in Oracle 11g.

• Select the type of layout you would like to generate:

We have three options here.

1.  Create both Web and Paper Layout,
2.  Create Web Layout only, 
3.  Create paper Layout only.

• Next step is  to  choose the report style and give a title name for your report. 

         The report style option are: Tabular, Group Left, Group Above, Matrix, Matrix with Group.

Step 4: Selecting a Data Source and Select Sql Query Builder for Reports in Oracle.

• In this step you have to choose a Data Source for your report. The Data Source can be from JDBC Query, SQL Query, Text Query, XML Query.
• In the next window you can write the query manually or else you can use Query Builder or Import Builder.

Example Query with Explanation:

SELECT * FROM MTL_SYSTEM_ITEMS_B WHERE SEGMENT1 =:P_SEGMENT1

In the above query: p_segment1 is called as bind parameter/variable.

Note: There are two types of parameters that we use in reports. Lexical Parameter and Bind Parameter

Bind Parameter: This is used to pass the values dynamically at run time.

Examples: 1) If you want to see only one item from your inventory and you want to select that item at the time of running report. 2) If you want select only particular department employees and you want to select that department at runtime.

Lexical Parameter: This parameter is used to build the query dynamically.

Examples: If you have two users A, B will be running the report and if use A want to see only columns 1, 2, 3 where as User B want to see columns 2, 3, 4 in that case we build the query dynamically using lexical parameters

• Select the fields that you would like to display in your report. You can move one item or all items to target from Available Fields in Displayed Fields.
• Select the fields that you would like to calculate totals in your report. Also you can choose to calculate: sum, count, minimum, maximum, average.
• In the Next screen here you can modify the labels of the fields and also the width for each field.
• Next Step is to select the template for your report. You have multiple options: Predefined Template, Template File or No Template

Now you are done with describing report.

Step 5:Run Module Report Editor Paper Design.

• Select the template for your report. You have multiple options: Predefined Template, Template File or No Template.