SSRS Expressions

• eobiki10

  SSCrazy

  Points: 2390

  More actions

  February 3, 2014 at 5:03 am

  #303678

  Hi All,

  I have a field that contains some names and would want to lift the name part that I want from the field. For example the field when run when will give "ACCOUNTANTS:- Signal Chartered Accountants @@ Individual:Mark John-Wilkinson" . So I need an expresssion that will give me Signal Chartered Accountants @@.

  Please there are other names in the field so I would need a generic expression that can lift such names from the field irrespective of the name.

  The task that I have is to be done with SSRS expressions only and not with SQL.

  EO

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  February 3, 2014 at 9:26 pm

  #1685726

  Something like....

  DECLARE @TextString VARCHAR(100) = 'ACCOUNTANTS:- Signal Chartered Accountants @@ Individual:Mark John-Wilkinson';

  DECLARE @StartPos INT,

  @EndPos INT;

  SELECT @EndPos = CHARINDEX('@@',@TextString);

  SELECT @StartPos = CHARINDEX(':-',@TextString)+2;

  PRINT @StartPos;

  PRINT @EndPos;

  SELECT RTRIM(LTRIM(SUBSTRING(@TextString,@StartPos,@EndPos-@StartPos)));

  Returns:Signal Chartered Accountants

  You should be able to use the expression in SSRS... or did you want to do it in VB.NET?

• eobiki10

  SSCrazy

  Points: 2390

  More actions

  February 7, 2014 at 10:20 am

  #1687138

  Thanks Pietlinden. Yes I was referring on how to do it in VB.net expressions although your SQL is so useful.