Steps to Create Report in Oracle Reports Builder 10g
Steps to Create Report in Oracle Reports Builder 10g
Step 1: Invoking Reports Builder and the Report Wizard
Step 2: Choosing the Layout Type
Step 4: Selecting the Data Source Type
Step 5: Building a Query using Query Builder
- Select Query Builder from the Query page in the Report Wizard.
- Enter your username, password, and alias in the Connect dialog box that appears if you have not already connected to the database.
- Select the data tables to build the query.
- Click Include. The tables appear in the selection area.
- Click Close to close the Select Data Tables window.
- In each table, double-click the column names that you want in the query, or use the check boxes. To select all columns, double-click the Table title bar.
- Click OK.
Step 6: Selecting Displayed Fields
Step 7: Totals and Labels
- If the initial label is wider than the field, Reports Builder allows enough space for the label, or displays it on multiple lines.
- If you increase the number of characters in the label text in the reentrant Wizard, the label can appear truncated in the report output.
Step 8: Selecting a Report Template
- Select the Predefined Template option button, if it is not already selected.
- Select a template from the Template list.
- Click Finish.
Leave a Reply
Want to join the discussion?Feel free to contribute!