Page 1 of 1

enter a symbol between text

Posted: Wed Dec 29, 2010 12:05 pm
by dina
hi i have a field in sql server contain string value now i want to separate this field for example my field is '1645' and i want to add ':' between that and show it like this
'16:45'
thanks

enter a symbol between text

Posted: Thu Dec 30, 2010 2:25 am
by Ivan
Hello,

You can use the following expression, for example:

Code: Select all

{YourDataSource.YourTextField.Insert(2,":")}
Please check the report sample in attachment.

Thank you.