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 instance.
AllowNull bit NOT NULL False (0) Reserved for future use.
Automatic bit NOT NULL False (0) Reserved for future use.
DataType nvarchar (128) NULL None Data type of Val1 and Val2.

0 = int
1 = float
2 = datetime
3 = char

FieldName nvarchar (128) NULL None Field in query used for expression.
Opnd1 tinyint NULL 0 First operand.
Opnd2 tinyint NULL 0 Second operand.
ParamName nvarchar (128) NULL None Tag name.
ParamType tinyint NULL None Type of parameter.
Val1 nvarchar (128) NULL None First value.
Val2 nvarchar (128) NULL None Second value.

Copyright © 2005 Microsoft Corporation.
All rights reserved.