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 | Identity. |
| AggregationType | tinyint | NULL | None | Not used. |
| Category | nvarchar (128) | NULL | None | Category of the report. |
| ChartType | int | None | 3 | See 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 (16) | NULL | None | Long description. |
| Description | nvarchar (128) | NULL | None | Additional information. |
| DisplayName | nvarchar (128) | NULL | None | Name displayed in the user interface. |
| DmExport | bit | None | False (0) | True (1) specifies the report is exportable to Direct Mail. |
| 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. |
| 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 or MDX query. |
| ReportType | tinyint | NULL | None | See 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. |
| 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) | True (1) specifies the report is exportable to User Personalization. |
| XMLData | ntext (16) | NULL | None | PivotTable XML data. |
Chart Types
Most Microsoft Office 2000 Web Components charts can be used. The following table lists a few of the more common chart types. ChartType Enum constants can be found in the file MSOWCVBA.CHM in the folder \Program Files\Microsoft Office\Office\1033 after a full Microsoft Office installation.
| ChartType | Value |
| Column: Clustered | 0 |
| Bar: Clustered | 3 |
| Line | 6 |
| Pie | 18 |
Report Types
The following table lists the valid report types.
| ReportType | Value |
| Dynamic_SQL | 0 |
| Dynamic_MDX | 1 |
| Static_SQL | 2 |
| Static_MDX | 3 |