In an ssrs 2008 report, I would like to select on only part of a value that displays on the report heading. I have tried to use the mid function so far, but I have not been able to select the correct part of the string I want to see.
An example of a value is 'Grace Elementary - 066 15-16 Grace Elem' and I want the value to look like
'066 15-16 Grace Elem' . Thus would you show me how to change the display value to be '066 15-16 Grace Elem'?