Packaging Custom Reports

  • Article

The following steps will guide you in packaging custom static reports so that they can be unpacked and run on another computer. In this procedure you will build a script to create a new report and then include this script in the script that is run by the Commerce Server Site Packager when new sites are installed.

  1. Open the NewStaticSQLReport.sql script or the NewStaticOLAPReport.sql script in the \Microsoft Commerce Server 2002\SDK\Samples\Business Analytics\Scripts folder.
  2. Use the sample report script and the instructions in the topic Creating Static Reports Using SQL or the topic Creating Static Reports Using MDX to create a new static report to reflect your reporting requirements.
  3. In SQL Query Analyzer, run the new script against the Data Warehouse database. During this step, the report definition will be written to the Data Warehouse.
  4. In the Business Desk Analysis Reports module, click Refresh. The newly created report will be available in the Reports module. Run this report and check the report functionality.
  5. Copy the script contents for the new report script and paste these script contents at the end of the file \Microsoft Commerce Server 2002\CSReports.sql.
  6. The file CSReports.sql will be included in your .pup package for propagation to other computers.
  7. On the destination computer, unpack the resources you packaged in the previous step. The custom report can now be run on the destination computer against the Data Warehouse associated with that computer.

Copyright © 2005 Microsoft Corporation.
All rights reserved.