现将sql中查出数据已Adquery 形式在fast report中显示，但sql 中显示数据在
fast report中变成了几个数45+44+44相加的和133 显示,而不是分开显示45,44,44 不知什么原因
下面为sql语句
select
zenbu.Workshop,
zenbu.qty,
case when
zenbu.Card#=zenbu.Card# and zenbu.Diffhours>23 and zenbu.Diffhours
then zenbu.Card# end as "卡",
zenbu.Diffhours as "小時",
zenbu.PO,
zenbu.[Style No],
zenbu.Diffday,
case when zenbu.Diffhours 0 and zenbu.Diffhours>23 and zenbu.Diffhours<49
then zenbu.Workshop end AS "小組",
zenbu.Intime,
zenbu.Outime
/*max(case when
zenbu.out2timecard=zenbu.out2timecard
OR zenbu.out3timecard =zenbu.out3timecard
OR zenbu.out4timecard =zenbu.out4timecard
OR zenbu.out5timecard =zenbu.out5timecard
OR zenbu.out6timecard =zenbu.out6timecard
then ltrim(rtrim(zenbu.Workshop)) end )as outWorkshop,
ltrim(rtrim(CONVERT(VARCHAR(19),zenbu.Intime,120)))as cintime,
ltrim(rtrim(CONVERT(VARCHAR(19),zenbu.Outime,120)))as coutime*/
/*
max(case when zenbu.Diffhours>2 and zenbu.Diffhours=3 then zenbu.Card# end )as Exceed2Hours,
max(case when zenbu.Diffhours=4 and zenbu.Diffhours
max(case when zenbu.Diffhours>6 and zenbu.Diffhours
max(case when zenbu.Diffhours>8 and zenbu.Diffhours
max(case when zenbu.Diffhours>25 and zenbu.Diffhours
max(case when zenbu.Diffhours>48 and zenbu.Diffhours<73 then zenbu.Card# end )as Exceed3day*/
/*case when zenbu.Diffday=24 and zenbu.Diffday is not null or zenbu.Diffday<36 then zenbu.Card# end as Exceed1day*/
/*case when DATEDIFF(HOUR,zenbu.Intime,zenbu.Outime)=2 and DATEDIFF(HOUR,zenbu.Intime,zenbu.Outime)<3
then zenbu.Card# end as Exceed2hours,*/
/*case when DATEDIFF(HOUR,zenbu.Intime,zenbu.Outime)=4 and DATEDIFF(HOUR,zenbu.Intime,zenbu.Outime)<5
then zenbu.Card# end as Exceed4hours*/
/*case when zenbu.qty=1 and zenbu.Outime IS null and
DATEDIFF(HH,zenbu.Intime,GETDATE())>12 then zenbu.Card# end as NoOutLine12Hours,
case when zenbu.qty=1 and zenbu.Outime IS null and
DATEDIFF(D,zenbu.Intime,GETDATE())>1 then zenbu.Card# end as NoOutLine1day*/
from(
select
tall.workshop,
tall.Intime,
tall.Outime,
tall.qty,
tall.card#,
tall.PO,
tall.[Style No],
DATEDIFF(HOUR,tall.Intime,tall.Outime) as Diffhours,/*givetimescount*/
case when tall.qty=1 and tall.Outime IS null then DATEDIFF(DAY,tall.Intime,GETDATE())end as Diffday,
case when tall.qty<>0 and datediff(HOUR,tall.Intime,tall.Outime)=2 then tall.cardno end as out2timecard,
case when tall.qty<>0 and datediff(HOUR,tall.Intime,tall.Outime)=3 then tall.cardno end as out3timecard,
case when tall.qty<>0 and datediff(HOUR,tall.Intime,tall.Outime)=4 then tall.cardno end as out4timecard,
case when tall.qty<>0 and datediff(HOUR,tall.Intime,tall.Outime)=5 then tall.cardno end as out5timecard,
case when tall.qty<>0 and datediff(HOUR,tall.Intime,tall.Outime)=6 then tall.cardno end as out6timecard,
case when tall.qty<>0 and tall.Inticket=4 and tall.exitticket IS null and
datediff(DAY,tall.Intime,GETDATE())=1 OR datediff(DAY,tall.Intime,tall.Outime)=1 then tall.cardno end as out1day,
case when tall.qty<>0 and tall.Inticket=4 and tall.exitticket IS null and
datediff(DAY,tall.Intime,GETDATE())=2 OR datediff(DAY,tall.Intime,tall.Outime)=2 then tall.cardno end as out2day,
case when tall.qty<>0 and tall.Inticket=4 and tall.exitticket IS null and
datediff(DAY,tall.Intime,GETDATE())=3 OR datediff(DAY,tall.Intime,tall.Outime)=3 then tall.cardno end as out3day,
case when tall.qty<>0 and tall.Inticket=4 and tall.exitticket IS null and
datediff(DAY,tall.Intime,GETDATE())=4 OR datediff(DAY,tall.Intime,tall.Outime)=4 then tall.cardno end as out4day,
case when tall.qty<>0 and tall.Inticket=4 and tall.exitticket IS null and
datediff(DAY,tall.Intime,GETDATE())=5 OR datediff(DAY,tall.Intime,tall.Outime)=5 then tall.cardno end as out5day,
case when tall.qty<>0 and tall.Inticket=4 and tall.exitticket IS null and
datediff(DAY,tall.Intime,GETDATE())=7 OR datediff(DAY,tall.Intime,tall.Outime)=7 then tall.cardno end as out7day,
case when tall.qty<>0 and tall.Inticket=4 and tall.exitticket IS null and
datediff(DAY,tall.Intime,GETDATE())>7 OR datediff(DAY,tall.Intime,tall.Outime)>7 then tall.cardno end as outweeksday
from(
select
total.Card# as cardno,COUNT(*)as qty,
total.Workshop,
total.Card#,
total.PO,
total.[Style No],
MAX(case when total.Ticket#=4 then total.Ticket# END) as Inticket,
MAX(case when total.Ticket#=20 then total.Ticket# END) as exitticket,
MAX(case when total.Ticket#=4 then total.[Receive Time] END) as Intime,
MAX(case when total.Ticket#=20 then total.[Receive Time] END) as Outime
from(
select
only.Ticket#,
only.[Receive Time],
only.Workshop,
only.Card#,
only.PO,
only.[Style No]
from test.dbo.TicketDetailData1420 only
group by
only.Workshop,
only.Card#,
only.Ticket#,
only.[Receive Time],
only.PO,
only.[Style No]
)total
where
total.Workshop=total.Workshop
group by
total.Workshop,
total.Card#,
total.PO,
total.[Style No]
/* order by
total.Workshop*/
)tall
where
tall.cardno=tall.cardno
/*order by
tall.Workshop*/
)zenbu
where zenbu.Workshop=zenbu.Workshop
and
zenbu.Diffhours <>0
and
zenbu.Diffhours>23 and zenbu.Diffhours<49
group by
zenbu.Workshop,
zenbu.Intime,
zenbu.Outime,
zenbu.qty,
zenbu.Card#,
zenbu.Diffhours,
zenbu.Diffday,
zenbu.PO,
zenbu.[Style No],
zenbu.out2timecard,
zenbu.out3timecard,
zenbu.out4timecard,
zenbu.out5timecard,
zenbu.out6timecard
order by
zenbu.Workshop
