Export Wizard dialog: Format and Name page

Use this dialog to specify what format you want to export to, and where to save files.

For more information, see:

Which export format do you want to use?

Use these drop down list to specify an export format for worksheets and graphs.

Table/Crosstab

Use this drop down list to specify an export format for worksheets. Format types supported include Oracle Reports (*.xml), Microsoft Excel, HTML, and Text.

Note: Web Query for Microsoft Excel (*.iqy) format is not available in a Single Sign-On environment. Contact the Discoverer manager or Oracle administrator for more information.
Graph

Use this drop down list to specify an export format for graphs. Format types supported include the following.
- Portable Network Graphics (*.png) - save graphs in PNG format (default). PNG format is an image file format that is common on the Web and supported by many business applications.
- GIF Image (*.gif) - save graphs in GIF format.
  
  Note: Graph files GIF format are limited to 256 colors, and thereby might be of lower quality than graph files in PNG format.
- HTML using PNG (*.htm) - save graphs as PNG embedded in HTML files.

Where do you want to save the file?

Use this field to specify where to save the exported data (for example, c:\data\reports). Type in a file location, or use the Browse button to navigate to a file location.

Browse

Use this button to display the Save dialog, where you navigate to a file location and choose a file name and export format.

What do you want to name the files

Use this field to change the default name of exported files. For example, if you change this value to Sales Analysis Report and export to Microsoft Excel format, Discoverer names the export file Sales Analysis Report.xls.

The following fields are displayed if you select the Web Query for Microsoft Excel (*.iqy) format in the What export format do you want to use? field

For more information, see "About exporting worksheets to Microsoft Excel Web Query format".

What information do you want to prompt Excel Web Query users for?

Use these check boxes to specify whether you want to prompt Excel end users for database login details and worksheet values when they open the worksheet in Microsoft Excel.

Connection Information

Use this check box to specify whether to prompt Excel end users for database login details when they open the worksheet in Microsoft Excel.
Page Item Values

Use this check box to specify whether to prompt Excel end users to filter the worksheet data using page items specified in that worksheet (only displayed if a worksheet has active page items). For example, if City is displayed in the Page Items area, you might want Excel end users to be able to choose to display data for New York, Boston, or Washington when they open the worksheet in Microsoft Excel.

If you select this check box, Discoverer displays the "Export Wizard dialog: Page Item Prompts page" as page 3 in the Export Wizard.
Parameter Values

Use this check box to specify whether to prompt Excel end users to filter the worksheet data using parameters in that worksheet (only displayed if a worksheet has active parameters). For example, if City is an active parameter, you might want Excel end users to be able to choose to display data for New York, Boston, or Washington when they open the worksheet in Microsoft Excel.

If you select this check box, Discoverer displays the "Export Wizard dialog: Parameter Prompts page" as page 4 in the Export Wizard.

Notes

For crosstab worksheets, if you select the Microsoft Excel Workbook with Pivot Table option in the Table/Crosstab drop down list, then Discoverer creates three sheets as follows:
- a base sheet that contains all the data in table format
- a sheet that contains the pivot table
  
  Note: The Discoverer worksheet's fonts and formatting are not preserved in the pivot table.
- a static sheet
To open an exported worksheet in Microsoft Excel, Microsoft Excel must have the correct security setting for macros. For example, in Microsoft Excel 2000, choose Tools | Macro| Security and set the security level to Medium or Low.
Export to PDF format is not available if you are running Discoverer Plus on JDK below Version 1.4. For more information, contact the Discoverer manager.
If you export a worksheet with a graph to PDF format, ensure that the worksheet fits on Letter paper size (that is, 8.5 x 11 inches). If the worksheet does not fit, reduce the width of the columns, or move the graph below or above the worksheet data area.