Share via

Create the Base Report Definition

  • Article

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

Step 3

INSERTINTO [dbo].[Report] ([DisplayName], [Description], [ReportType], [Category], [CreatedBy], [Protected], [ShowPivot], [ShowChart], [XMLData], [Definition])

VALUES ('Registered Users', 'Registered Users', 0, 'Visits', 'user', 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.

Ee825193.note(en-US,CS.10).gif Note

  • Do not modify the XML structure after the report is initially created. Make any modifications to the report 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.


All rights reserved.