Post reply

Counting the number of Characters in a cell (SSRS)

  • March 30, 2010 at 9:26 am

    #231358

    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.

  • April 5, 2010 at 5:38 pm

    #1146115

    Can you use =Len(Fields!Cell1.Value) ?

  • April 5, 2010 at 9:20 pm

    #1146244

    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!

  • April 5, 2010 at 11:00 pm

    #1146283

    What about SELECT LEN(column1) AS totalCharacters FROM table1 ?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply