Create the Base Report Definition

Insert the required parameters, including the XMLString created in Step 2, into the XMLData field in the Report table.

Step 3

INSERTINTO [dbo].[Report] ([DisplayName], [Description], [ReportType], [Category], [CreatedBy], [Protected], [ShowPivot], [ShowChart], 
[XMLData], [Definition]) 
VALUES ('Registered Users', 'Registered Users', 0, 'Visits', 'Report Creator', 0, 1, 0, XMLString, 'Use this report to view information on the registered users of the site.')

When the above steps have been successfully completed, the report will appear in the Reports module of Commerce Server Business Desk. The next step is to run the report from Business Desk. For more information, see Running Reports.

Note

• Do not modify the XML structure after the report is initially created. Make any modifications to the report by using the pivot table component in the Analysis category in Business Desk. The pivot table view and layout changes are automatically persisted in the XML for the report when it is saved.

Copyright © 2005 Microsoft Corporation.
All rights reserved.