Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Share this Page URL

Lesson 3: Modifying The Display > Practice Solutions 3 - Pg. 90

Oracle Discoverer 10g: Create Queries & Reports (Windows) Page 90 Practice Solutions 3 The objective of this exercise is to change the format of data and headings. The remainder of the practice exercises assumes that you are already running Discoverer Desktop, and that you know how to perform basic tasks such as saving and closing workbooks. 1. Create a workbook using the Workbook Wizard. In the first step, specify that you want to create a Page-Detail Crosstab report and continue to the next step. (a) Select File/New... from the menu. (b) Click the Create a new workbook button. (c) Click the Page-Detail Crosstab button for the display style. (d) Click the Next> button to proceed to the second step. 2. In the second step, select the following items for inclusion in your query from the Camp Source business area: Sale Summary: Employee Name, Sale Date, Sale Date Year, Total Sale SUM, Employee Commission SUM. (a) Expand the Sale Summary folder to display its items.