Expression Placeholder Text (Reporting Services)

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

When you drag items from the Data pane to the report design surface, you see placeholder text for the underlying expression values for a text box.

The following table shows the display text and the underlying expression text.

Built-in Collection Display text Expression text

Dataset Fields

[Sales]

[SUM(Sales)]

[FIRST(Store)]

=Fields!Sales.Value

=Sum(Fields!Sales.Value)

=First(Fields!Store.Value)

Report parameters

[@Param]

[SUM(@Param)]

=Parameters!Param.Value

=Sum(Parameters!Param.Value)

Built-in Fields

[&ReportName]

=Globals!ReportName.Value

ReportItems text box collection

[$Textbox1]

=ReportItems("Textbox1").Value

=ReportItems.Textbox1.Value

Static value

\[Sales\]

[Sales]

See Also

Reference

Expression Examples in Reporting Services

Concepts

Examples of Group Expressions (Reporting Services)
Using Parameters in Expressions
Working with Fields in a Report Dataset (Reporting Services)

Other Resources

Using Expressions in Reporting Services (Reporting Services)
NIB Working with the Data Pane (Reporting Services) x
Working with Parameters in Reporting Services

Help and Information

Getting SQL Server 2008 Assistance