常用备忘

页次
="页　　次："+(Globals!PageNumber).ToSTRing() +"-"+ (Globals!TotalPages).tostring()

没资料显示字眼
在Tablix detail row 按右键Insert row >> outside group Below,
在新增栏位的fx,放置语法如下:
=IIf(RowNumber(Nothing)=0,"＊＊无资料＊＊","")

怎样让每页都有表头
Column Groups /Advanced Mode
Row Groups {static}属性 设定
RepeatOnNewPage = True
KeepWithGroup = After
FixedData = True
https://blog.darkthread.net/blog/rdlc-repeat-header-each-page/

这个页面(群组)的总计
="＊＊合计＊＊　笔数："+RowNumber("gp_point").ToString()+" 点数："+sum(Fields!point.Value).ToString()

奇偶列相间
=Iif(RowNumber(Nothing) Mod 2, "LemonChiffon", "White")

Q:选字体时,选不到标楷体 /Arial Unicode MS
A:选不到没关係,直接贴上就可以了.

插入图片
External : 如果value是网址,选这个

如果是1就显示logo,如果不是就不显示
插入影像/一般 :选档案
可见性:依据运算式显示或隐藏 *编辑的话,在图像按右键/影像属性/可见性/依据运算式显示或隐藏
=IIF(Parameters!TradeType.Value="1",false,true)

如果1,就显示xxxx,如果2就显示aaaa,如果3就显示bbb
=IIF(Parameters!SYS.Value="1","xxxx","")
+IIF(Parameters!SYS.Value="2","aaaa","")
+IIF(Parameters!SYS.Value="3","bbb","")

Parameters 字串 20181101 变成107/11/01
=cstr(left(Parameters!DATE1.Value,4)-1911)+"/"+ mid(Parameters!DATE1.Value ,5,2)+ "/"+mid(Parameters!DATE1.Value ,7,2)

Parameter日期变yyyyMMdd
=Cint(Format(Parameters!YourDate.Value, "yyyyMMdd"))
https://stackoverflow.com/questions/31253180/convert-a-date-to-an-integer-in-yyyymmdd-format-in-ssrs

列印日期 本来是 yyyy/MM/dd hh:mm:ss >>> yyyy/MM/dd
="列印日期："+Format(Globals!ExecutionTime,"yyyy/MM/dd")
="列印日期："+Format(Cdate(Globals!ExecutionTime),"yyyy/MM/dd")

列印日期(日期变民国年)
="列印日期："+Format(Globals!ExecutionTime.AddYears (-1911),"yyy/MM/dd")
="列印日期："+Format(Cdate(Globals!ExecutionTime).AddYears (-1911),"yyy/MM/dd")