2012 年 8月 23 日随笔档案 - chunshen

2012年8月23日

摘要： =iif(Fields!Year.Value=2012 and Fields!month.Value=2,29,iif(Fields!Year.Value=2013 and Fields!month.Value=2,28,iif(Fields!month.Value<8 and Fields!month.Value mod 2=1,31,iif(Fields!month.Value<8 and Fields!month.Value mod 2=0,30,iif(Fields!month.Value>7 and Fields!month.Value mod 2=0,31,30) 阅读全文

posted @ 2012-08-23 23:58 chunshen 阅读(257) 评论(0) 推荐(0) 编辑

从参数中获得特定字符串

摘要： =left(right(right(Fields!ts.Value,4),len(right(Fields!ts.Value,4))-Instr(right(Fields!ts.Value,4),"[")),Instr(right(right(Fields!ts.Value,4),len(right(Fields!ts.Value,4))-Instr(right(Fields!ts.Value,4),"[")),"]")-1) 阅读全文

posted @ 2012-08-23 23:28 chunshen 阅读(181) 评论(0) 推荐(0) 编辑

栏目数据合并表达式

摘要： =iif(Fields!门店.Value="莘庄",nothing,Fields!门店.Value) & "" & iif(Fields!门店2.Value="无",nothing,Fields!门店2.Value) 阅读全文

posted @ 2012-08-23 20:29 chunshen 阅读(218) 评论(0) 推荐(0) 编辑