Expression Reference (Report Builder 3.0 and SSRS)

Report expressions support a variety of references to built-in functions and built-in collections. Expressions must have valid Visual Basic syntax before a report can be published or processed.

To develop complex expressions or expressions that use custom code or custom assemblies, we recommend that you use Report Designer in Business Intelligence Development Studio. For more information, see Custom Code and Assembly References in Expressions in Report Designer (SSRS).

Note

You can create and modify report definitions (.rdl) in Report Builder 3.0 and in Report Designer in Business Intelligence Development Studio. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder 3.0 (SSRS) on the Web at microsoft.com.

Use the topics in this section to help write simple expressions in a report.

In This Section

Working with Data Types in Expressions (Report Builder 3.0 and SSRS)

Using Constants in Expressions (Report Builder 3.0 and SSRS)

Using Operators in Expressions (Report Builder 3.0 and SSRS)

Using Built-in Collections in Expressions (Report Builder 3.0 and SSRS)

Using Built-in Globals and Users References (Report Builder 3.0 and SSRS)

Using Parameters Collection References (Report Builder 3.0 and SSRS)

Using Dataset Fields Collection References (Report Builder 3.0 and SSRS)

Using DataSources and DataSets Collection References (Report Builder 3.0 and SSRS)

Using Report and Group Variables Collections References (Report Builder 3.0 and SSRS)

Using the ReportItems Collection References (Report Builder 3.0 and SSRS)

See Also

Concepts

Expressions (Report Builder 3.0 and SSRS)