ReportInstanceParam Table
The following table stores an instance of the parameterized query expression. This table is created at report run time.
Attribute name | Data type | Constraint | Default | Description |
ReportStatusID | int | NOT NULL | None | ID of the report status. |
ParamName | nvarchar (128) | NULL | None | Tag name. |
ParamType | tinyint | NULL | None | Type of parameter. |
DataType | nvarchar (128) | NULL | None | Data type of Val1 and Val2.
0 = int |
Opnd1 | tinyint | NULL | 0 | First operand. |
Val1 | nvarchar (128) | NULL | None | First value. |
Opnd2 | tinyint | NULL | 0 | 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. |