Creating Dynamic Reports Using SQL

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

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

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

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

   The report shows up in the Reports section of the Analysis module of 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.

For more information about using Business Desk to create new dynamic report definitions, see Creating a New Dynamic Report Definition.

Note

• The Microsoft Commerce Server 2002 Software Development Kit (SDK), which is included with Commerce Server 2002, contains six SQL script files that enable you to create static and dynamic reports that query either SQL or OLAP data sources. The script files to create these reports are located in the installation folder under \Microsoft Commerce Server\SDK\Samples\Business Analytics\Scripts. For more information, see New Report Scripts.

Copyright © 2005 Microsoft Corporation.
All rights reserved.