Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Text Functions (Report Builder 1.0)

Use Text functions to manipulate the text in your report. For example, suppose you want cities and states to be displayed together. Using the CONCAT function, you can create a field where both are displayed together.

Text functions can use the following data types: String and Integer.

Topic

Description

CONCAT (Report Builder 1.0)

Concatenates two strings together into one.

FIND (Report Builder 1.0)

Position of the first instance of a string.

LEFT (Report Builder 1.0)

Returns the left most characters of a string.

LENGTH (Report Builder 1.0)

Returns the number of characters in a string.

LOWER (Report Builder 1.0)

Converts a string from uppercase characters to lowercase.

LTRIM (Report Builder 1.0)

Returns a string with the leading spaces removed.

REPLACE (Report Builder 1.0)

Returns a string with all the instances of a sub-string replaced by another sub-string.

RIGHT (Report Builder 1.0)

Returns the right most characters of a string.

RTRIM [(Report Builder 1.0)

Returns a string with the trailing spaces removed.

SUBSTRING (Report Builder 1.0)

Returns a sub-string from within a string.

UPPER (Report Builder 1.0)

Converts a string from lowercase characters to uppercase.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.