fyiReporting Software, LLC
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.