经常遇到将类似201103这样的数字转换为Mar-11类型的需求。当其中有空值时则报表中会显示#error。如下代码可修正:

=iif( 

cdate(iif(isnothing(Fields!EndExtension.Value),"01/01/1900","01/" &
 right(Fields!EndExtension.Value,2) &"/" & left(Fields!EndExtension.Value,4)))="01/01/1900","", 
 cdate(iif(isnothing(Fields!EndExtension.Value),"01/01/1900","01/"&right(Fields!EndExtension.Value,2) &
  "/" & left(Fields!EndExtension.Value,4))).ToString("MMM-yy")
  )