Tutorial: Oracle Report Builder

1. From the Class.Schedule.Fall2006.html web page, copy the script file for the Inventory Database.
2. Start SQL Plus. Go to:

   Start > Programs > Oracle > Application Development > SQL Plus

   [For 4th floor computer lab: Start > All Programs > Oracle > Oracle SQL Plus > SQL Plus]

3. When the login window appears, logon using your oracle account username, password, and connect string (info464).
4. At the SQL Plus prompt, paste the SQL syntax to create the Inventory Database.
5. At the SQL Plus prompt, type exit and hit return. This will close the SQL Plus window.
6. Start OC4J Instance. Go to:

   Start > Programs > Oracle > Developer Suite > Reports Developer > Start OC4J Instance

   [For 4th floor computer lab: Start > All Programs > Oracle Developer Suite > Reports Developer > Start OC4J Instance]

   ** Let this window run in the background. Do not close the window, just minimize it.

7. Start Report Builder. Go to:

   Start > Programs > Oracle > Oracle Developer Suite > Reports Developer > Report Builder.

   [For 4th floor computer lab: Start > All Programs > Oracle > Oracle Developer Suite > Reports Developer > Reports Builder]

8. At the welcoming window, select 'Use the Report Wizard' and click OK.
9. Select 'Create both web and paper layout'. Click Next.
10. Enter the title Package and choose the report style Tabular. Click Next.
11. Choose 'SQL Query'. Click Next.
12. On the next screen, click 'Query Builder'. Login.
13. From the Select Data Tables window:
    1. Select Tables and Views.
    2. Select the Package table.
    3. Click Include.
    4. Click Close.
14. Select Packid, Packname, Packtype, and Packcost.
15. Click on the Sort button (AZ) on the toolbar. Double-click on Packname to sort the output on package name.
16. Click on OK twice.
17. Review the PL/SQL query that appears. Click Next.
18. Select all available fields to be displayed by clicking on the double arrows, >>. Click Next.
19. Do not select any columns for which to calculate totals. Click Next.
20. Do not modify any Labels and Widths. Click Next.
21. Select default options. Click Next.
22. Click Finish. Wait for your report to be generated.
23. You should be able to see the Report Editor.
24. From the Report Editor window, try to change the position of the various columns by clicking once on it, and dragging it to a new place.
25. Press CTRL + S to save your report. Choose the directory location, c:\temp. Choose the name package.jsp.
26. Press CTRL + R to run your report.
27. If you see only HTML code in the browser, that means the content was blocked.
    1. Hit F5 to refresh the screen.
    2. Click OK on the Information Bar pop-up window.
    3. Right-click on the yellow strip and select the option 'Allow Blocked Content'.
    4. Click Yes on the Security Warning pop-up window.
    5. Click Yes on the Internet Explorer pop-up window.
28. You should be able to see the report you just created in the browser.