Repository navigation
Expression Overview
Expressions
The expression language is based on VB .Net functions and expressions. The operators +,-,/,*,^,% provide the basics for constructing an expression. Numerous builtin functions allow you to act on the five global collections (see below). Items in collections are accessed by the following syntax:
Collection!ObjectName or Collection.Item(ObjectName)
Fields
This collection consists of the fields defined in the dataset. The dataset used depends upon the context of the expression. For example, an expression in a Table uses the dataset of the Table. For example, the expression =Fields!salary.Value refers to the salary field's value.
Parameters
This collection consists of the parameters defined in the report. For example, the expression =Parameters!SalaryParameter.Value refers to the report parameter SalaryParameter.
ReportItems
This collection consists of the names of the Textboxes included on the page. The ReportItems collection should only be used on the report header and footer. For example, the expression =First(ReportItems!ContactName) will show the first ContactName on the page.
Globals
| Name | Description | Example |
|---|---|---|
| PageNumber | The current page number. | =Globals!PageNumber |
| TotalPages | Total numbers of pages. | =Globals!TotalPages |
| ExecutionTime | The datetime the report started. | =Globals!ExecutionTime |
| ReportFolder | Current path of the report | =Globals!ReportFolder |
| ReportName | Name of the report | =Globals!ReportName |
Users
| Name | Description | Example |
|---|---|---|
| UserId | The current user. Only useful when running in ASP. | =Users!Name |
| Language | Language of user running report. | =Users!Language |
You can extend the builtin functionality by creating or referencing your own functions. Report code and Report modules allow you to either write your own or use externally written functions.
- Home
- Report Topics
- Designer
- Examples
- RdlViewer
- Desktop Server
- Command Line Utility