=Mid( First( Fields!ItemId.Value, "ProdRouteCardDS" ), 1, InStr( First(Fields!ItemId.Value, "ProdRouteCardDS" ), "_" ) - 1 )Output will be:
ABC-156032
Microsoft AX 2012, X++, C#, SQL server, SSRS, Java, JavaFX, Oracle, PL/SQL, Delphi - codes examples, step-by-step tutorials, experiences.
=Mid( First( Fields!ItemId.Value, "ProdRouteCardDS" ), 1, InStr( First(Fields!ItemId.Value, "ProdRouteCardDS" ), "_" ) - 1 )Output will be:
ABC-156032