Creating Dynamic Reports
This topic describes creating dynamic reports using an XML framework which contains either an SQL query or a reference to a cube. New dynamic reports can be created from existing dynamic reports by running the existing report, editing the pivot view, and saving the result as a new report. If the new report requires a different SQL query or cube than any existing report, a SQL script must be run. Scripts are provided that can be modified to create both types of dynamic reports. These scripts are located in the installation folder under \Microsoft Commerce Server\SDK\Samples\Business Analytics\Scripts.
New dynamic reports are created by following these steps:
Run the modified SQL script to create the basic report.
Open the newly created report or an existing dynamic report.
Modify the report using the features of the pivot control.
Save the customized report as a new report.
When the above steps have been successfully completed, the new report will appear in the Reports module of Commerce Server Business Desk.
This section contains:
Creating Dynamic Reports Using SQL. Describes creating dynamic reports using an XML framework containing an SQL query.
Creating Dynamic Reports Using Cubes. Describes creating dynamic reports using an XML framework containing a reference to a cube.