Oracle9i Discoverer Desktop User's Guide
Version 9.0.2 for Windows
A90886-01

Home
Solution Area
Contents
Index

Prev Next

6
Reporting Results

This chapter explains how to create reports with Discoverer Desktop.

Topics in this chapter include:

6.1 Preparing Reports for Printing

Tables and crosstabs are displayed in a format that easily lends itself to reporting of results. Additional options, such as adding headers and footers, page numbers, and the date, help you prepare the report for printing.

Here is an example of a table and a printed version of it as a report.

Figure 6-1 Sample Table and Report


Key to Figure 6-1.

    1. The Discoverer Worksheet.

    2. The Worksheet Report generated by Discoverer.

    3. The Report Header section.

    4. The Header contains the Date, Workbook name, and Worksheet name.

    5. The Report Body section, which contains the Worksheet data.

    6. The Report Footer section, containing a variable for the page number.

6.1.1 Selecting Print Options

Use the Page Setup dialog box to add print options to a report.

To select print options:

  1. Choose File | Page Setup.

    The Page Setup dialog box appears. The tabs across the top of the dialog box list the various types of options you can select to design the report.

Figure 6-2 Page Setup for Worksheets


  1. Click the Header tab to see the options for the report's header. The options for footers are the same.

Figure 6-3 Page Setup for Header and Footer


Key to Figure 6-3.

    1. Click Insert to insert system variables (such as Date, Time, or Worksheet name etc) into the Left Section, Center Section, and Right Section. Then click Add to add them to the header or footer.

    2. Enter text here for the header or footer, or add system variables using the Insert option.

    Available Headers--Lists headers you have already created. Click the drop-down arrow to see the list. Select the one you want on your report. The names are derived from the text typed into the boxes for the Left, Center, and Right sections.

    To create a new header (or footer), choose <none> from the drop-down list. Enter the header text in the three boxes for the Left, Center, and Right sections. Click the Add button. That header is added to the drop-down list. To remove a header from the list, select it and click the Remove button.

    Line Width--Sets the width of a line that separates the header from the body of the report. Choose No Line if you don't want a separating line on the report.

    Left, Center, Right Sections--Displays the text of the header selected in the Available Header list above. To edit a header, click in a box and type the new text. By default, the Left Section's text is left-justified, the Center's text is centered, and the Right Section's text is right-justified.

    Insert--Lists information that you can add to the header. Click in the text where you want the inserted information to appear, then choose from the list to add a text code to the header or footer. The text code is a "placeholder" for variable information in the report.

    In the following figure, &Date is the placeholder for the current date when the report is printed. Because the inserted information is in the Left Section box, the current date appears at the left side of the page on the printed report.

Figure 6-4 Insert Header/Footer Text


  1. Click the Margin tab to see the options for the report's margins.

Figure 6-5 Page Margins Setup for Reports


Margins--Sets the margins on the page. Click the up and down arrows next to a margin setting to increase or decrease it.

From Edge--Sets the distance of the header and footer from the edge of the paper. Click the up and down arrow to increase or decrease the distance. Note that the distance from the edge of the page cannot be greater than the margin; otherwise, the header or footer would print in the table or crosstab. For example, if the bottom margin is 1.00, the footer cannot be 1.25.

  1. To see the results of the Page Setup options, click the Preview button. A preview of the report appears on the screen. See the next section for details.

  2. Click OK to put all the page setup settings into effect.

6.1.2 Previewing a Report

To preview a report, click the Preview button on the Page Setup dialog box or choose File | Print Preview. The Print Preview window appears and shows a representation of the printed report.

Figure 6-6 Print Preview Window


The buttons across the top of the Print Preview window are for selecting preview options:

6.2 Sending Reports with E-Mail Messages

You can send worksheets, graphs, and selections of a table or crosstab as part of an e-mail message. This feature is available for most e-mail applications, however, if it does not appear on the menu, your e-mail application does not support the feature.

To send a report with an e-mail message:

  1. Display the worksheet that you want to send as a report.

    • To send only a section of the worksheet with the e-mail, select that section by dragging over it.

    • To send a graph, display the graph first by choosing Graph | Show.

  2. Choose File | Send.

    The Prepare Mail dialog box appears.

Figure 6-7 Prepare Mail Dialog Box


Figure 6-8 E-Mail Attachment Format Options


  1. Click the Send button.

    Your e-mail application starts. Based on your selections on the Prepare Mail dialog box, the worksheet or workbook is either an attachment or the message text of the e-mail message.

6.3 Exporting to Other Applications

You can export tables and crosstabs in a variety of formats to open them in other applications. For example, you can export a table to a Microsoft Excel workbook or a Lotus 1-2-3 spreadsheet and then use Excel or Lotus 1-2-3 to open the table.

Exporting a table or crosstab exports the data, formatting, and layout of the table or crosstab. Exporting does not export the calculations, conditions, or other tools that you define in Discoverer. In other words, you can view the exported data in another application, but you cannot apply the Discoverer tools to it in that application. 

To export to other applications:

  1. Display the worksheet that you want to export.

  2. Choose File | Export.

    The Export dialog box appears. See the previous section for a description of the export options.

Figure 6-9 Export Dialog Box


  1. Choose an export format from the drop-down menu.

  2. Choose a directory to save the export file.You can also type the directory path in the box. Click the Browse button to see other directories.

  3. Enter a name for the report in the directory path.

    For example, in the dialog box shown above, the path is C:\ORAWIN95\DISCVR31\vidstore.dis.txt where vidstore.dis.txt is the name of the report.

    To rename the report in that path to Sales_Figures, select vidstore.dis.txt and then type Sales_Figures.

  4. Click Finish.

The report is saved in the new format in the directory you specified.

6.3.1 Exporting to Oracle Reports

If your computer includes the Oracle Reports application, you can export tables and crosstabs from Discoverer as an Oracle Report. Having this capability means that you can apply the extensive formatting features of Oracle Reports to your Discoverer reports.

To export to Oracle Reports:

  1. Display the worksheet that you want to export to Oracle Reports.

  2. Choose File | Export.

    The Export dialog box appears.

Figure 6-10 Export to Oracle Reports, Step 1


  1. Choose Oracle Report Definition File (*.rdf) as the export format.

  2. Choose a directory to save the export file. You can also type the directory path in the box. Click the Browse button to see other directories.

  3. Enter a name for the report in the directory path.

  4. Click Next.

    The dialog box for choosing the report's template appears.

Figure 6-11 Export to Oracle Reports, Step 2


The dialog box has options for selecting a report template that you created earlier in Oracle Reports.

Do not use template (unformatted)--exports the report with no formatting, fonts, or colors.

Select a predefined template--select a template for the report from the drop-down menu; the list shows templates already predefined in Oracle Reports.

Select a custom template file--if you created a custom template in Oracle Reports earlier, it will be listed here; select a template from the drop-down menu.

View Report in--select this option if you want to see what the report looks like in the Oracle Reports format.

Report Runtime--view the report in the Oracle Reports runtime.

Report Designer--view the report in the Oracle Reports Designer application; you can then edit the report using Designer's features.

  1. Click Finish.

The template is applied to the report, and the report is saved in the directory that you specified earlier. You can open the report in Oracle Reports, or any other application that supports Oracle Reports.

6.3.2 Exporting to Microsoft Excel

The Excel tool on the tool bar helps you export Discoverer tables and crosstabs quickly to Microsoft Excel.

To export to Excel:

  1. Display the worksheet you want to see in Microsoft Excel.

  2. Click the Excel tool on the tool bar.

Figure 6-12 The Excel Tool


The worksheet is saved in .xls format, and Microsoft Excel opens to display the worksheet.

Figure 6-13 Sample Table and Report


Key to Figure 6-13.

    1. The Discoverer Worksheet.

    2. The Worksheet converted to Microsoft Excel spreadsheet format (*.xls) and displayed in Microsoft Excel.

    3. Notice that unformatted data is displayed. Currency symbols, decimal places, and percentage formatting are not displayed. This formatting can be re-applied in Microsoft Excel.


6.4 Producing Scheduled Reports

Scheduled reports are workbooks set to run at a specified time. For example, you may want to run a worksheet at the end of each month that calculates monthly profits from monthly sales figures, or run a report every two weeks based on a worksheet that produces a biweekly cash flow analysis.

Often, worksheets that you want to use as scheduled reports are designed specifically for that purpose, rather than being a worksheet for your day-to-day analysis. For example, the worksheet may include special calculations or conditions that produce the results you want for the scheduled report on a periodic basis only.

You can select all or some of the worksheets in a workbook to run as a scheduled report. Typically you schedule reports if:

Because a scheduled report runs on the server, you do not need to leave your computer running overnight (or whenever you schedule the report to run). The results of running the scheduled report are saved on the server as well and, therefore, are available when you log on to the server and start Discoverer.

When working with a complex set of data or a complicated worksheet, the time it takes to load the worksheet may exceed the time limit the Database Administrator set for worksheets to open. In that case, a Schedule button appears on the message box that tells you the worksheet loading time exceeds its time limit. You can then click the Schedule button to schedule the worksheet as a report so it will load later without being restricted by the time limit. 

To schedule a report:

  1. Open the workbook that contains the worksheets that you want to schedule to run as reports.

  2. Choose File | Schedule.

    The Schedule Workbook dialog box appears.

Figure 6-14 Schedule Workbook Dialog Box, Step 1


  1. Click in the box next to a worksheet title to include that worksheet as part of the scheduled report.

    • Click Select All to include all of the workbook's worksheets in the report.

    • Click Select None to remove the checkmark from each box.

  2. Enter the time and date to run the report.

    To change the time and date, click on the numbers you want to change, then either type the new time or date, or click the up and down arrows. For example, to change 08:00 PM to 12:01 AM, click on the 08 and either type 12 or click the up arrow until 08 becomes 12. Then click on the 00 and type 01 or click the up arrow once. Then click on PM and click either arrow; PM changes to AM.

  3. Select one of the options for how often you want to repeat the schedule:

    Never--runs the scheduled report once and only once.

    Repeat every--runs the report on a periodic basis; enter a number and select a time interval from the drop-down menu. For example, to run a monthly report, enter 1 Month in the selections.

  4. Click Next.

Figure 6-15 Schedule Workbook Dialog Box, Step 2


  1. Enter a name for the scheduled report.

  2. (Optional) Enter a description for the scheduled report. This is particularly helpful if you've created several scheduled reports. The description appears on the Scheduling Manager dialog box.

  3. Enter a length of time to keep the results of the scheduled report stored on the server. After that period of time the results are automatically deleted from the server. If you've saved the results as a worksheet on your local computer, that worksheet remains intact.

  4. Click Finish.

The workbook and its worksheets are now scheduled and run based on the options you selected in the Schedule Workbook dialog box.

6.4.1 Seeing the Results of a Scheduled Report

A scheduled report produces a worksheet or set of worksheets with the results derived from running the report. You can see those results when first starting Discoverer, or while working in a workbook.

To see the results of a scheduled report when starting Discoverer:

  1. Start Discoverer and log on in the normal manner.

    The window appears for selecting what to open.

  2. Click the button, Open an existing workbook.

Figure 6-16 See a Scheduled Report Results


  1. Click the Scheduling Manager button.

    The Open Scheduled Workbook dialog box opens. It lists the completed reports.

Figure 6-17 Open Scheduled Workbook Dialog Box


  1. Select the completed scheduled report you want to see.

  2. Click Open.

    The workbook opens and displays the worksheets generated by the scheduled report.

    The worksheets produced by running the scheduled report contain data derived specifically for that report. You can now work with the worksheet in the normal manner, but if you change any of its data, a message reminds you that the data on the worksheet is no longer the specific data derived from the report. 

6.4.1.1 Viewing Scheduled Workbooks when connected as an Oracle Applications User

When connected as an Oracle Applications User, the following rules apply:

6.4.2 Working with the Scheduling Manager

With the Scheduling Manager you can see the results of a scheduled report, schedule a new report, reschedule a report, or edit a report's schedule.

To run the Scheduling Manager, choose File | Manage Workbooks | Scheduling Manager. The Scheduling Manager dialog box appears.

Figure 6-18 Scheduling Manager

Key to Figure 6-18.

    1. Discoverer reports scheduled to run. The clock icon indicates that the reports are scheduled to run at the time specified by Date and Time.

    2. Completed Discoverer report ready to open. The report icon indicates that the reports were generated at the Date and Time indicated.

The Scheduling Manager shows scheduled reports and completed reports. The clock icon indicates a scheduled report set to run at a specified time. The icon without a clock indicates a completed report. Other information in this dialog box includes the following:

Name--the names of the scheduled reports or completed reports. You can open completed reports. You cannot open scheduled reports, though you can edit the schedule configuration if required.

Status--status types include scheduled, completed, in progress, out of date (expired), deleted by the database administrator, unable to be scheduled, had an error during the report run, and so on.

Date and Time--either the date and time a scheduled report is set to run or the date and time a completed report was run.

Run time--the length of time needed by the server to complete a scheduled report.

To schedule a new report from the Scheduling Manager dialog box:

  1. Click the Schedule button.

    The Schedule Workbook dialog box appears.

Figure 6-19 Schedule Workbook Dialog Box


  1. Click either My Computer or Database to identify the location of the workbook that contains the worksheets for the scheduled report.

  2. Click Schedule. The Open dialog box appears.

  3. Select the workbook and worksheets to schedule as reports.

  4. Schedule the reports as described earlier.

To see the results of a scheduled report:

  1. Select the completed report in the list.

  2. Click Open.

    Note: The Open button is only available when you select a completed report.

    The workbook containing the completed report opens and displays the worksheets that you designated as a scheduled report.

To delete a completed report:

  1. Select the completed report in the list.

  2. Click Delete.

    Note: The Delete button is only available when you select a completed report. It changes to Unscheduled when you select a scheduled report in the list.

To unschedule a scheduled report:

  1. Select the scheduled report.

  2. Click the Unschedule button.

    Note: The Unschedule button is only available when you select a scheduled report. It changes to Delete when you select a completed report in the list.

    Unscheduling a report deletes it from the list.

To edit the settings of a scheduled report:

  1. Select the scheduled report in the list.

  2. Click the Edit button.

    The Schedule Workbook dialog box appears. The Schedule tab is selected.

Figure 6-20 Schedule Workbook Dialog Box for Editing


This dialog box is almost the same as the dialog box you used to create the scheduled report except you cannot add or delete the sheets in the scheduled report from this dialog box. To do that you need to create a new scheduled report by choosing File | Schedule.

  1. Make the scheduling changes that you want.

  2. Click the General tab.

  3. Make the changes on that dialog box that you want.

  4. Click OK.

    The schedule in the Scheduling Manager dialog box updates to include your changes. Now the scheduled reports will run based on the updated settings.

6.4.2.1 Viewing Errors

In the event an error occurs while the scheduled workbook is running, the status of the report will be "Error while running query" or "Could not schedule."

To view a message that explains the error:

  1. Click the scheduled report that did not run properly.

  2. Click the View Error button.

    A message shows the error code and text.

6.5 Sharing Workbooks

Sharing a workbook grants other people access to it to view, analyze, and print the data. You can share workbooks with other people by setting up sharing two ways:

Sharing workbooks lets others use and analyze the same data. For example, you may want everyone in the accounting department to share a workbook that includes accounts payable and accounts receivable information. Similarly, you may want a project manager to have access to all the workbooks created for the project.

To share workbooks, choose File | Manage Workbooks | Sharing. The Share Workbooks dialog box appears. The two tabs at the top of the dialog box are for assigning workbooks to users or users to workbooks.

Figure 6-21 Share Workbooks Dialog Box


Workbook -> User--click this tab to share one workbook with several other people.

User -> Workbook--click this tab to share several workbooks with one other person.

To share a workbook with several other people:

  1. Click the Workbook -> User tab.

  2. Choose the name of the workbook that you want to share from the drop-down list.

  3. In the list of Available Users, click the name of a person with whom you want to share the workbook.

  4. Click Add. The person's name appears in the Shared column.

    The list of names in the Shared column are the people who can have access to the workbook.

  5. Repeat for all the other people with whom you want to share the workbook.

  6. Click OK.

To share several workbooks with one other people:

  1. Click the User -> Workbook tab.

  2. Choose the name of the person with whom you want to share the workbook from the drop-down list.

  3. In the list of Available Workbooks, click the name of a workbook that you want to share the other person.

  4. Click Add. The workbook's name appears in the Shared column.

    The list of names in the Shared column are the workbooks the other person can share with you.

  5. Repeat for all the other workbooks that you want to share the other person.

  6. Click OK.

Prev Next
Oracle
Copyright © 2002 Oracle Corporation.
All Rights Reserved.

Home
Solution Area
Contents
Index