Features of Dynamic and Static Reports

  • Article

The following table lists the differences between static and dynamic reports.

Feature Dynamic report Static report
Control size of report results You control the size of report results by not displaying detailed data. You control the size of report results by limiting the number of rows in the report definition.
Change the contents of the report You use the PivotTable feature to add and remove dimensions and measures from the report results, specify filters, and expand or collapse dimension levels. The system administrator modifies static reports programmatically. For instructions about modifying static reports, see Creating Custom Reports in Commerce Server 2002 Help.
Export report results directly to List Manager You cannot export the results of a dynamic report to List Manager. You can export a static report to List Manager as either a dynamic or static list.
Export report results to Microsoft Excel You can export the results of a dynamic report to Microsoft Excel. You cannot export a static report to Microsoft Excel.
Create new report definitions You can modify existing dynamic reports or create new ones based on a SQL Server query or an OLAP cube. For instructions about creating new dynamic report definitions, see Creating a New Dynamic Report Definition. The system administrator can modify static reports programmatically. For instructions about modifying static reports, see Creating Custom Reports in Commerce Server 2002 Help.
Delete report definitions You can delete custom dynamic report definitions. You cannot delete default dynamic report definitions. You can delete custom static report definitions. You cannot delete default static report definitions.
Save completed reports You cannot save completed dynamic reports with data in Business Desk. Completed static reports are stored with their data in the Completed Reports module in Business Desk until you delete them.
View report results as a chart You can view completed dynamic reports as PivotCharts. You cannot view completed static reports as charts.
Use the drillthrough feature to view additional report data for selected reports For dynamic OLAP reports you can double-click a cell in the PivotTable data area to retrieve the detailed data for that cell. The drillthrough feature is not available for static reports.

See Also

Reports Accessing OLAP Cubes and SQL Server

Scripts for Securing Databases Accessed by Reports

Copyright © 2005 Microsoft Corporation.
All rights reserved.