sql server reporting services: count number of lines in a clumn -- sql server reporting services

count number of lines in a clumn

Helen
5/15/2006 2:43:02 PM

sql server reporting services: The SP returns a column which contains
Error: 1212121
Error: 3434fsfa
Error: fdfdfd

Each above line has Char(10) + Char(13) attached so they will start a new line

Now I want to know the number of errors returns by using pattern "Error". Is
there any function I can use to do this?

Re: count number of lines in a clumn

Joe L
5/15/2006 5:26:50 PM

In SQL you could do something like:

(LEN(columname) - LEN(REPLACE(columnname, 'Error' , '') ) / 5

I am not sure what the equivalent VB.Net syntax would look like to do it in
SRS.

[quoted text, click to view]