ReportParam Table
The following table describes the attributes used to create a parameterized query for a static report.
| Attribute name | Data type | Constraint | Default | Description |
| ReportID | int | NOT NULL | None | ID of the report with which the parameter is associated. |
| ParamName | nvarchar (128) | NOT NULL | None | Tag name. |
| ParamDescription | nvarchar (128) | NOT NULL | None | Text displayed on the clickable bar. |
| ParamType | tinyint | NOT NULL | 0 | Type of parameter. |
| DataType | tinyint | NULL | None | Data type of Val1 and Val2.
0 = int |
| Opnd1 | tinyint | NULL | None | First operand. |
| Val1 | nvarchar (128) | NULL | None | First value. |
| Opnd2 | tinyint | NULL | None | Second operand. |
| Val2 | nvarchar (128) | NULL | None | Second value. |
| FieldName | nvarchar (128) | NULL | None | Field in query used for expression. |
| Ordinal | tinyint | NULL | None | Used to specify the user interface rendering order. |
| AllowNull | bit | NOT NULL | False (0) | Reserved for future use |
| Automatic | bit | NOT NULL | False (0) | Reserved for future use. |