0

In one of my reports a name field is bringing through people's names as:

john.smith

I have added =StrConv(Fields!name.value,vbProperCase). This now brings them through as John.Smith, which is better, but is there a way of removing the full stop between 'john' and 'smith'?

Any suggestions welcome, thanks.

Pedram
  • 6,256
  • 10
  • 65
  • 87
Will F
  • 417
  • 2
  • 6
  • 17

1 Answers1

0

If possible adjust the output data in the query itself if that is not in your control then use following expression 

 = Left(Fields!name.value, Len(Parameters!User.Value) - InStr(Parameters!User.Value, "."))+" "+ Right(Fields!name.value, Len(Parameters!User.Value) - InStr(Parameters!User.Value, "."))

Let me know in case of issue.

Mahesh
  • 8,694
  • 2
  • 32
  • 53