Skip to content

Latest commit

 

History

History
43 lines (32 loc) · 3.2 KB

add-an-expression-report-builder-and-ssrs.md

File metadata and controls

43 lines (32 loc) · 3.2 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom
Add an expression to a paginated report
Find out about how to use expressions to define report item properties, filters, and parameter values in Report Builder.
kfollis
kfollis
09/25/2024
reporting-services
report-design
conceptual
updatefrequency5

Add an expression to a paginated report (Report Builder)

[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]

Expressions are used throughout paginated reports for defining report item properties, filters, groups, sort order, connection strings, and parameter values. Expressions begin with an equal sign (=) and are written in [!INCLUDEmsCoName] [!INCLUDEvisual-basic]. They're evaluated at run time by the report processor, which combines the evaluation result with report layout elements.

Expressions can be simple or complex. Simple expressions refer to a single item in a built-in collection. Complex expressions can contain constants, operators, global collection items, and function calls. For more information, see Expressions (Report Builder).

Note

[!INCLUDEssRBRDDup]

Add an expression to a text box

  • In Design view, select the text box on the design surface to which you want to add an expression.

    • For a simple expression, enter the display text for the expression in the text box. For example, for the dataset field Sales, enter [Sales].

    • For a complex expression, right-click the text box, and select Expression. The Expression dialog opens. Enter or interactively create your expression after the '=' in the expression pane, and then select OK.

      The expression appears on the design surface as <<Expr>>.

Related content