Update the Grouped Report SDK Sample Script

  • Article

Update the script to customize your grouped report.

To open the grouped report SDK sample

  1. Click Start, point to Programs, point to Accessories, and then click Windows Explorer.
  2. Navigate to the grouped report scripts in the SDK, for example C:\Program Files\Microsoft Commerce Server 2002\SDK\Samples\Business Analytics\Scripts.
  3. Open the file corresponding to the type of database the information is stored in. If you are using an SQL database, double-click the NewGroupedSQLReport.sql icon. If you are using an OLAP database, double-click the NewGroupedOLAPreport.sql icon.

To update the NewGroupedSQLReport.sql script

  1. Replace the text in the following table with the appropriate content for your report.

    Text in script Replace with
    Insert report name here The report name.
    Report description - short A short description of the report.
    Insert report category here The report category.
    Insert report creator here The name of the person that is creating the report.
    Report description - long Optional. A detailed description of the report.

  2. Update the SQL query provided in the NewGroupedSQLReport.sql script. For more information about changing an SQL query, see Writing the SQL Query.

    The SQL query must be in the form Select into [$ResultTable]. The temporary table name for the [$ResultTable] tag is determined by ReportRenderer. This tag must appear in the query but it should not be changed.

  3. Update the report definition in the script. For more information about report definitions, see Creating the SQL Base Report Definition.

  4. Update the report dimensions. For more information about report dimensions, see Adding the SQL Report Dimensions.

    The [GroupDim] fields on the insert statements for the row dimensions are used to specify the grouping.

  5. On the File menu, click Save As to save your script changes.

  6. In the File Name box in the Save As dialog box, type a name for the new script, and then click Save.

To update the NewGroupedOLAPReport.sql script

  1. Replace the text in the following table with the appropriate content for your report.
    Text in script Replace with
    New grouped OLAP report name here The report name.
    Report description - short A short description of the report.
    Insert report category here The report category.
    Insert report creator here The name of the person creating the report.
    Report description - long Optional. A detailed description of the report.
  2. Update the MDX query provided in the script. For more information about changing an MDX Query, see Writing the MDX Query.
  3. Update the report definition in the script. For more information about report definitions, see Creating the MDX Base Report Definition.
  4. Update the report definitions. For more information about report definitions, see Adding the MDX Report Definitions.
  5. To save your script changes, on the File menu, click Save As.
  6. In the File Name box in the Save As dialog box, type a name for the new script, and then click Save.

Copyright © 2005 Microsoft Corporation.
All rights reserved.