I am trying to format the Name column through the format property. Rather than to create the named calculation in the DSV and then use it as a name column. I did this test both in 2008 r2 and 2012 and both have the same behaviour that format is not going to change and it’s showing the original value.
Even I put my name in the format though process run successfully.
I did some investigation and found very useful post of Dan English in which he got response from Microsoft:
Response from Microsoft:
The “Format” string for Attribute names is a stub for a later addon and is not implemented. Attribute names will only accept WChar types. Any formatting should be done either in the data source view as a “Named Calculation” or in the source table/view on the relational source.
The above reply is in June 2007 and now is February 2013 this issue still persist in 2012 release.
Don’t use the Name column format property, use the named calculation technique which mentioned above.
Please read/vote for this Microsoft Connect suggestion: