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
1 = float
2 = datetime
3 = char

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.


All rights reserved.