Custom Reports

You can modify a dynamic report definition and save it as a custom report definition, which is added to the Reports module. You use custom dynamic report definitions to create a new view of the data in a dynamic report. For example, you can run the Usage Trend report to see the total requests, users, and visits per year for your site.

If you want to see more details about usage trends, you can create a new dynamic report definition from the Usage Trend report to show you usage trends by the type of user who is visiting your site, or to show you usage trends over different time periods (per day, per month, or per quarter) instead of per year. When you save the Usage Trend report with your changes, the new report definition is added to the Reports module. Refresh the Reports list in the Reports module to show the new dynamic report definition. For more information about creating a new dynamic report definition, see Creating a New Dynamic Report.

You create a custom dynamic report definition by changing the PivotTable of an existing report, and saving the result as a new report definition. You can change the PivotTable of an existing report by adding and removing filters, sorting the displayed data, adding measures, moving fields, changing the data that is detailed and summarized, and by pivoting (or manipulating) the columns and rows. For example, you can expand the year dimensions of the Usage Trends report and see usage trends by day. You can expand the year dimensions, remove the year, quarter, and day dimensions and see usage data by month only.

For more information about working with PivotTables,  Your system administrator can create custom static and dynamic report definitions and add them directly to the database used by reports.

See Also

Commerce Server Reports

Running Reports

Creating a New Dynamic Report