| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | |
|---|---|---|---|---|---|---|---|---|---|
Expression reference in a paginated report |
Learn about the syntax required in expressions, before processing or publishing a paginated report, to support references to built-in functions and collections in Report Builder. |
kfollis |
kfollis |
09/25/2024 |
reporting-services |
report-design |
conceptual |
|
[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]
Paginated report expressions support a variety of references to built-in functions and built-in collections. Expressions must have valid [!INCLUDEvisual-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 [!INCLUDEssBIDevStudioFull]. For more information, see Custom Code and Assembly References in Expressions in Report Designer (SSRS).
Note
[!INCLUDEssRBRDDup]
Use the topics in this section to help write simple expressions in a report.
Data Types in Expressions (Report Builder and SSRS)
Constants in Expressions (Report Builder and SSRS)
Operators in Expressions (Report Builder and SSRS)
Built-in Collections in Expressions (Report Builder and SSRS)
Built-in Globals and Users References (Report Builder and SSRS)
Parameters Collection References (Report Builder and SSRS)
Dataset Fields Collection References (Report Builder and SSRS)
DataSources and DataSets Collection References (Report Builder and SSRS)
Report and Group Variables Collections References (Report Builder and SSRS)