年收入统计

chinshaw

我在做报表 年收入统计 为什么报错~无效数字。具体代码如下
select bd_psndoc.psncode"bd_psndoc.psncode",bd_psndoc.psnname"bd_psndoc.psnname",sum(wa_data.f_16)"岗位工资",sum(wa_data.f_74)"驻外津贴",sum(wa_data.f_163)"补发",sum(wa_data.f_31)"综合津贴(合计)",sum(wa_data.f_30)"综合津贴(劳务)",sum(wa_data.f_17)"综合津贴(正式)",sum(wa_data.f_64)"综合津贴（劳务）1",sum(wa_data.f_61)"综合津贴1",sum(wa_data.f_59)"工龄计算",sum(wa_data.f_37)"经营体",sum(wa_data.f_101)"考核结果",sum(wa_data.f_15)"绩效工资",sum(wa_data.f_75)"保育费",sum(wa_data.f_80)"高温费",sum(wa_data.f_81)"中班费",sum(wa_data.f_82)"夜班费",sum(wa_data.f_83)"劳防费",sum(wa_data.f_33)"卫生福利费",sum(wa_data.f_88)"就餐扣",sum(wa_data.f_76)"加班费",sum(wa_data.f_78)"保健费",sum(wa_data.f_79)"值班费",sum(wa_data.f_84)"营养费",sum(wa_data.f_77)"养老补贴",sum(wa_data.f_164)"附加工资",sum(wa_data.f_21)"奖励费",sum(wa_data.f_43)"部门奖励费",sum(wa_data.f_36)"职级制奖励费",sum(wa_data.f_183)"技术中心奖励费",sum(wa_data.f_73)"经验输入奖励费",sum(wa_data.f_182)"支部书记奖励费",sum(wa_data.f_55)"高温奖励费",sum(wa_data.f_42)"专利奖励费",sum(wa_data.f_40)"团委奖励费",sum(wa_data.f_41)"质量保证部奖励费",sum(wa_data.f_38)"持续改善办奖励费",sum(wa_data.f_44)"安全保障部奖励费",sum(wa_data.f_46)"上汽奖励费",sum(wa_data.f_47)"总经办奖励费",sum(wa_data.f_49)"手工焊奖励费（劳务）",sum(wa_data.f_50)"留沪奖励费（劳务）",sum(wa_data.f_39)"返乡费（劳务）",sum(wa_data.f_32)"星级津贴(劳务)",sum(wa_data.f_62)"星级津贴1",sum(wa_data.f_22)"一次性奖",sum(wa_data.f_179)"部门质量安全奖",sum(wa_data.f_180)"劳动竞赛",sum(wa_data.f_23)"嘉奖(劳务)",sum(wa_data.f_65)"各厂明星员工",sum(wa_data.f_66)"各厂管理奖",sum(wa_data.f_67)"各厂特殊补贴",sum(wa_data.f_69)"各厂超产奖",sum(wa_data.f_70)"各厂质量奖惩",sum(wa_data.f_72)"各厂其他费用",sum(wa_data.f_147)"应发工资",sum(wa_data.f_85)"歇工扣",sum(wa_data.f_86)"缺勤扣",sum(wa_data.f_173)"缺勤扣（病假）",sum(wa_data.f_174)"缺勤扣（事假）",sum(wa_data.f_175)"缺勤扣（百分率）",sum(wa_data.f_177)"缺勤扣（中心）",sum(wa_data.f_45)"个人养老",sum(wa_data.f_48)"个人医疗",sum(wa_data.f_51)"个人失业",sum(wa_data.f_68)"个人公积金",sum(wa_data.f_89)"会费",sum(wa_data.f_18)"党费",sum(wa_data.f_90)"住宿费"
from wa_data  inner join  bd_psndoc on wa_data.psnid = bd_psndoc.pk_psndoc  left outer join  bd_psncl on wa_data.nestpsnclid = bd_psncl.pk_psncl  left outer join  bd_deptdoc on wa_data.nestdeptid = bd_deptdoc.pk_deptdoc  left outer join  om_job on wa_data.pk_om_job = om_job.pk_om_job  left outer join  bd_defdoc on om_job.jobseries = bd_defdoc.pk_defdoc  left outer join  bd_defdoc as bd_defdoc_2 on om_job.jobrank = bd_defdoc_2.pk_defdoc  left outer join  bd_defdoc as bd_defdoc_3 on om_job.groupdef1 = bd_defdoc_3.pk_defdoc  left outer join  bd_defdoc as bd_defdoc_4 on om_job.groupdef2 = bd_defdoc_4.pk_defdoc  left outer join  wa_waclass on wa_data.classid = wa_waclass.addflag  left outer join  wa_bank on wa_data.bankid = wa_bank.accbankid  left outer join  bd_psnbasdoc on bd_psndoc.pk_psnbasdoc = bd_psnbasdoc.pk_psnbasdoc  left outer join  bd_defdoc as bd_defdoc_5 on bd_psndoc.jobseries = bd_defdoc_5.pk_defdoc
where (wa_data.cnestyear =#year# )and (wa_data.cnestperiod between #start# and #last#)
group by
bd_psndoc.psncode,bd_psndoc.psnname

andyaidajia

看这个东东，不好看问题。看下NCHOME/NCLOGS下的日志，查看下日志抛什么错误？在哪里抛错？