日期:2014-05-20  浏览次数:20957 次

RDLC分组取部分数据该怎么分组
我现在有一组数据A,把他们在RDLC上按照年龄分组, 1-20岁是一组,20-40岁是一组,40-60岁是一组,60岁以后是一组。
报表表达式如下:
=IIF(First(Fields!年龄.Value)<=20 and First(Fields!年龄.Value)>=1,"少年",(IIF(First(Fields!年龄.Value)>=21 AND First(Fields!年龄.Value)<=40,"青年",(IIF(First(Fields!年龄.Value)>=41 AND First(Fields!年龄.Value)<=60,"中年","老年")))))
现在在报表分组中我想去掉最后一个“老年”分组,请问应该怎么办?
求牛人。 


------解决方案--------------------
要写表达式的话,也可以试试Switch

=Switch(First(Fields!年龄.Value)<=20 and First(Fields!年龄.Value)>=1,"少年",First(Fields!年龄.Value)>=21 AND First(Fields!年龄.Value)<=40,"青年",First(Fields!年龄.Value)>=41 AND First(Fields!年龄.Value)<=60,"中年")