Exporting a Dynamic Report

You use the PivotTable controls to export a completed dynamic report to Microsoft Excel. You use Microsoft Excel to save, modify, and print completed dynamic reports. To export a completed dynamic report to Microsoft Excel, you must have Microsoft Excel installed on the same computer on which your completed dynamic report resides.

To export a completed dynamic report to Microsoft Excel

1. Contact your system administrator to import data into the Data Warehouse and to run the Report Preparation DTS task to make the data available for reports.

2. In Analysis, click Reports. In the list of available reports, select the dynamic report definition you want to run, and then click on the toolbar.

   The completed dynamic report appears as a PivotTable in a new browser window.

   Note

   • If the PivotTable is not visible, click on the toolbar.

3. To open your report in Microsoft Excel, in the PivotTable screen, click on the PivotTable toolbar.

The report appears as a Microsoft Excel spreadsheet.

See Also

About Dynamic and Static Reports

Commerce Server 2002 Reports

Running Reports

Exporting a Static Report

Exporting a Report to List Manager

Copyright © 2005 Microsoft Corporation.
All rights reserved.