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
The SSRS DateDiff function is a Date and Time function that calculates the difference between two given date fields (total number of time intervals) and returns the long value. For instance, the total years between the hire date and termination or the total days between the order and ship date. The syntax of the SSRS … Read more
The SSRS DateAdd function is a Date and Time function that adds or subtracts the specified time interval from the given date fields and returns the Date value. For instance, it adds three years to the joining date or two days to the order date as the ship date. The syntax of the SSRS DateAdd … Read more
The SSRS DatePart function is a Date and Time function that will help you extract individual date parts (specified component) from the given date fields and return the integer value. For instance, extract years, months, hours, days, etc., from the order date for analysis purposes. The syntax of the SSRS DatePart function to return the … Read more
The SSRS TimeSerial function is a Date and Time function that constructs a time value from the specified hour, minute, and second information and sets the date value to January 1 of the year 1. The syntax of the TimeSerial function to build the required time from the hour, minute, and second is as shown … Read more
The SSRS DateSerial function is a Date and Time function that will construct a date value from the specified year, month, and day information and set the time value to midnight (00:00:00). If your data has individual year, month, and day columns, use this DateSerial to construct the complete date. The syntax of the SSRS … Read more
