In this case, we will start from an empty new report and use the Oracle Report Wizard to help us creating a basic report for commodity groups, parts, and codes.
-
Open the Reports Developer.
-
Select Use the Report Wizard, and click OK.
-
Select the Show this page next time option if you don’t want to display the Welcome screen every time you use the wizard.
-
Click
to start the wizard-based report building method.
-
Select Create Paper Layout only, and click Next >.
-
From the available report types, select the Tabular style for our example, and click Next >.
-
You will be asked for the data source type. Select SQL Query (see Specify a Base Query to Support the Requirements) and click Next >.
-
In the following dialog box with a SQL text box, click Connect to connect to the target database.
-
In the Connect dialog box, type the username m_sys, the m_sys password, and the database connectstring, and click Connect.
-
In the SQL text box dialog box, add the query that will be used for the report. In our example, paste the query from the Specify a Base Query to Support the Requirements section above.
Alternatively, you can use the Query Builder tool provided by Oracle to generate the new query.
-
Click Next >.
-
A message appears that shows you the new parameters created for the report to facilitate the filtering based on either commodity group, part, or code. Click OK to continue.
-
In the next dialog box, you can select the fields (columns) you want to display in the report. Click
to include all columns, and click Next > twice.
Now define the labels for each column on the report layout, and adjust the width of each column, as shown in the picture below. When done, click Next >.
-
On the next dialog, you can choose to use predefined report layout templates. In our example, we use the Beige template. Click Next > to continue.