Skip to content

Expression Overview

Paulo Soares edited this page May 29, 2018 · 1 revision

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.

Clone this wiki locally