Report Table
The following table describes the attributes used in the main report definition table.
| Attribute name | Data type | Constraint | Default | Description |
|---|---|---|---|---|
| ReportID | int | None | None | Unique identifier. |
| AggregationType | tinyint | NULL | None | Not used. |
| Category | nvarchar (128) | NULL | None | Category of the report. |
| ChartType | int | None | 3 | See "Chart Types" table immediately following. |
| CommerceBuild | nvarchar (128) | NULL | None | Commerce Server build number. |
| CreatedBy | nvarchar (128) | NULL | None | Name of the user who created the report. |
| CreatedTime | datetime | NULL | getdate() | Date and time the report was created. |
| Definition | ntext | NULL | None | Long description. |
| Description | nvarchar (128) | NULL | None | Short description. |
| DisplayName | nvarchar (128) | NULL | None | Name displayed in the user interface. |
| DmExport | bit | None | False (0) | If True (1), the report contains the rcp_Email field, which can be exported to List Manager for use by Direct Mailer. |
| HelpFileRef | nvarchar (256) | None | None | Help file name. |
| LastModifiedBy | nvarchar (128) | NULL | None | Name of the user who last modified the report. |
| LastRunBy | nvarchar (128) | NULL | None | Name of the user who last ran the report. |
| LastRunDateTime | datetime | NULL | None | Date and time the report was last run. |
| MajorVersion | int | NULL | None | None. |
| MinorVersion | int | NULL | None | None. |
| ModifiedTime | datetime | NULL | None | Date and time the report was last modified. |
| OrderBy | nvarchar(512) | None | None | Used to order the static SQL report results. |
| Private | bit | None | False (0) | Not used. |
| Protected | bit | None | False (0) | True (1) indicates the report may not be overwritten or deleted. True for all system reports. |
| Query | nvarchar (2000) | NULL | None | The executable SQL query. |
| ReportType | tinyint | NULL | None | See "Report Types" table immediately following. |
| SeriesInColumns | bit | None | True (1) | Inverts the chart (swaps x and y). |
| ShowChart | bit | None | False (0) | True indicates to show the chart. |
| ShowDefinition | bit | NOT NULL | None | True indicates to show the definition. |
| ShowLegend | bit | None | True (1) | True indicates to show the chart legend. |
| ShowPivot | bit | None | True (1) | True indicates to show the pivot control. |
| UPMExport | bit | None | False (0) | If True (1), the report contains the rcp_GUID field, which can be exported to List Manager for use by the Profiling system. |
| XMLData | ntext | NULL | None | PivotTable XML data. |
Chart Types
Most Microsoft Office XP Web Components charts can be used with reports created by Commerce Server. The following table lists a few of the more common chart types. The chart type can be selected directly in the Chart control.
| ChartType | Value |
| Column: Clustered | 0 |
| Bar: Clustered | 3 |
| Line | 6 |
| Pie | 18 |
Report Types
The following table lists the valid report type values.
| ReportType | Value |
| Dynamic_SQL | 0 |
| Dynamic_MDX | 1 |
| Static_SQL | 2 |
| Static_MDX | 3 |
| Static_Grouped_SQL | 4 |
| Static_Grouped_MDX | 5 |
Copyright © 2005 Microsoft Corporation.
All rights reserved.