Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Counting the number of Characters in a cell (SSRS) Expand / Collapse
Author
Message
Posted Tuesday, March 30, 2010 9:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 28, 2013 9:58 AM
Points: 54, Visits: 161
Hi all.

Is there a simple way of counting the characters in a specific text cell in ssrs?

Like COUNT(DISTINCT... only it would be the number of characters....

eg

cell 1 abcdefghiklmnopqrstuvwxyz. Intended result is "26"

I have to say this has been a great resource for me. Thank you all.
Post #892934
Posted Monday, April 5, 2010 5:38 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 1:28 AM
Points: 138, Visits: 372
Can you use =Len(Fields!Cell1.Value) ?
Post #897146
Posted Monday, April 5, 2010 9:20 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 28, 2013 9:58 AM
Points: 54, Visits: 161
I was actually hoping to get the count from the query side:

SELECT COUNT(characters(table1)) as totalCharacters... or whatever it is supposed to be!
Post #897278
Posted Monday, April 5, 2010 11:00 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 1:28 AM
Points: 138, Visits: 372
What about SELECT LEN(column1) AS totalCharacters FROM table1 ?
Post #897319
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse