ReportParameter Element (RDL)

  • Article

Describes an individual parameter in the report.

Syntax

<ReportParameters>
        <ReportParameter Name="...">
              <DataType>...</DataType>
              <Nullable>...</Nullable>
              <DefaultValue>...</DefaultValue>
              <AllowBlank>...</AllowBlank>
              <Prompt>...</Prompt>
              <Hidden>...</Hidden>
              <MultiValue>...</MultiValue>
              <ValidValues>...</ValidValues>
              <UsedInQuery>...</UsedInQuery>
        </ReportParameter>
</ReportParameters>

Element Characteristics

Characteristic Description

Data type and length

None

Default value

None

Cardinality

1-n: Required element that occurs once or more than once.

Element Attributes

Attribute Type Description

Name

String

Name of the parameter. Required.

Element Relationships

Relationship Element

Parent element

ReportParameters

Child elements

AllowBlank, DataType, DefaultValue, Nullable, Prompt,

Hidden

MultiValueValidValues, UsedInQuery

Remarks

The Name attribute for the ReportParameter element must be unique within the ReportParameters parent element. The value for Name must be a case-insensitive identifier that is compliant with the Common Language Specification (CLS).

See Also

Reference

Report Definition XML Elements

Help and Information

Getting SQL Server 2005 Assistance