请问大家怎样把报表里的0显示为空白呢?
比如:表1(此表是个临时表,里面的记录是重别的表中插入的)
F_ID F_name F_num1 F_num2 F_num3
1 aaa 1 0 0
2 bbb 0 2 00显示为空白,结果如下:
F_ID F_name F_num1 F_num2 F_num3
1 aaa 1
2 bbb 2 F_num1,F_num2,F_num3 是int型的
比如:表1(此表是个临时表,里面的记录是重别的表中插入的)
F_ID F_name F_num1 F_num2 F_num3
1 aaa 1 0 0
2 bbb 0 2 00显示为空白,结果如下:
F_ID F_name F_num1 F_num2 F_num3
1 aaa 1
2 bbb 2 F_num1,F_num2,F_num3 是int型的
你是要在sql里显示空白的话,把字段改成文字类型(一样是临时表,有什么好挑剔的)要在报表里显示空白可以设置条件格式-_-
insert into @t select 1,'aaa',1,0,0
union all select 2,'bbb',0,2,0select F_ID,F_name,nullif(F_num1,0),nullif(F_num2,0),nullif(F_num3,0) from @t
create table #temp2 (F_ID int,F_name char(25),F_num1 int,F_num2 int,F_num3 int)insert into #temp2 select 1,'aaa',1,0,0 union all
select 2,'bbb',0,2,0select F_ID,F_name,replace(F_num1,0,''),replace(F_num2,0,''),replace(F_num3,0,'')
from #temp2