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.