Using Functions in Expressions

Built In Functions

Stimulsoft Reports has a large number of built in functions available for you to use. You can access these functions directly from the data dictionary and within the Expression Editor. Examples of built in functions and their usage would be:

{Trim(MyString)}

or

{Trim(MyDataSource, MyDataColumn)}

In each case the use of the Trim function removes leading and trailing spaces from the result shown in the report.

.NET Framework Methods

In addition to the built in functions you can use any available .Net Framework methods. For string expressions you could use any of the following examples:

{MyString.Trim()} // Removes leading and trailing spaces

{"Test".ToUpper()}// Converts the value to upper case "TEST"

{MyString.Length}// Returns the length of the string - if the value of MyString is "Test" then the method will return 4

For numerical expressions you could use any of the following examples:

{Math.Round(MyValue, 2)}// Rounds the value to two decimal places

{Math.Sqrt(MyValue)}// Returns the square root of MyValue

{MyValue.ToString() + " times"} // Converts the number to a string and adds the word "times" -

                         // if MyValue is 5 this returns "5 times"

There are no limits to the number of Framework methods you can access - if they are available within .NET for the type you are using in a report you can use them without restriction.