报表服务中怎样使用文本函数

帅呆呆发布于 2014-12-11 20:50， 534 次点击

请老师帮帮忙，怎么给字段【性别】使用Trim()函数

只有本站会员才能查看附件，请登录

3 回复

xiaofu2222014-12-30 17:54

Right-click handle of the Gender column, then click Expression.
In expression text box, type the expression like below: =Trim(Fields!Gender.Value)

xiaofu2222014-12-30 17:54

Right-click handle of the Gender column, then click Expression.
In expression text box, type the expression like below: =Trim(Fields!Gender.Value)

antjl2014-12-31 09:43

SQL中没有直接的Trim函数，用RTrim(LTrim())两个函数组合来代替