Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2009-05-20 : 05:53:50
|
My report contains a Memo field - but sometimes the memo field has the contents of lots of emails inside it.I'd like to only display the first 100 or so characters. I need to be able to create the expression to do thisThe field is called "CallDesc"I tried Left(Cstr(Fields!Calldesc.Value),100) but this returns an error"The hidden expression in textbox 'CallDesc' returned a data type that is not valid. |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2009-05-20 : 06:29:03
|
| I should have read the error more closely. There was a hidden expression in the text box properties |
 |
|
|
|
|
|
Trying to get only the part of a memo field