Creating Dynamic Reports Using SQL

  • Article

New dynamic SQL reports are described as a running example in the following sections. To create the report, follow these steps:

  1. Create the SQL query. For details on this step, see Create the Dynamic SQL Query.

  2. Create the XML framework which includes the query. For details on this step, see Create the XML Framework.

  3. Insert the XML and other report parameters into the Report table. For details on this step, see Create the Base Report Definition.

  4. The report shows up in the Reports section of the Analysis module of the Business Desk where it is modified using the pivot control and saved.

A SQL script file, "Analysis - New dynamic SQL report script.sql", is included in the SDK. This script includes the XML framework and can be modified to create the report. The file is located in the installation folder under \Microsoft Commerce Server\SDK\Samples\Business Analytics\Scripts.


All rights reserved.