The SSRS Abs function is a Mathematical function that returns the absolute positive value of a single-precision floating-point number. The syntax of the Abs function to return the absolute value of a numeric field is as shown below. =Abs(-10.50)=Abs(Fields!PositiveNegative.Value) To demonstrate the Reporting Services Abs function, we use the Products table below, which has 14 … Read more
The SSRS Split function is a Text function that will split the given string into the number of substrings using the specified delimiter. It may be space, comma, etc., and returns a zero-based one-dimensional array. So, to access the splitter substring, you must use the index, which starts from 0 to n-1. The syntax of … Read more
The SSRS FormatPercent function is a Text function that formats the expression or numeric field calculation as a percentage with a trailing % character. By default, this function multiplies the expression by 100, so you don’t have to do it while calculating the percentage. The syntax of the SSRS FormatPercent function to format the numeric … Read more
The SSRS FormatCurrency function is a Text function that formats the numeric (number) fields as the currency value and assigns the currency symbol defined in the system control panel. The syntax of the FormatCurrency function to assign a currency symbol to the formatted numeric fields is as shown below. Here, the second argument is the … Read more
The SSRS FormatNumber function is a text function that formats the expression or numeric fields as numbers and controls the decimal values. The syntax of the FormatNumber function to format the numeric fields or numbers is as shown below. Here, the second argument is the decimal precisions. =FormatNumber(Fields!SalesAmount.Value, 2) To demonstrate the SSRS FormatNumber function, … Read more
The SSRS Replace function is a Text function that will replace the part of a string field with the user-given substring and return a string—for instance, changing the word or set of characters in the product description. The syntax of the SSRS Replace function accepts three arguments, as shown below. The first argument is the … Read more
The SSRS StrComp function is a Text function that performs a string comparison of two fields and returns -1, 0, or 1 based on the result. For instance, if both are the same, it returns 0. If the second argument is greater than the first, it returns -1, and if the first argument is greater … Read more
The SSRS StrConv function is a Text function that will convert the given string field or expression to the specified one, such as converting a string to lowercase or uppercase. The syntax of the StrConv function to perform the string conversion is shown below. =StrConv(Fields!ProductDescription.Value, vbProperCase) To demonstrate the SSRS StrConv function, we use the … Read more
The SSRS StrDup function is a Text function that repeats the given character a specified number of times and returns a string or object. Although you provide a complete string, it considers the first character and repeats that one. The syntax of the SSRS StrDup function accepts two arguments, as shown below. The first argument … Read more
The SSRS Space function is a Text function that will add a return to the specified number of spaces and return a new string. For instance, add a space between the first and last names. The syntax of the Space function to return user-given empty spaces as a string is shown below. =Space(3) To demonstrate … Read more
