错误代码:1301 数据集配置错误Query:ORA-01722: 无效数字
用报表做的会议，数据从oracle数据库读的，一直用的好好的。
1.可以正常打开这周及之前的会议报表，可以正常显示内容，图1；
2.点击“下一周”，就出现如图2错误，再点击“下一周”会出现图3错误。
不知道问题，在哪里，各位高手给指点一下。补充一下SQL代码：
select TA.BEGINDATE || ' 周' || decode((to_char(to_date(TA.BEGINDATE,'yyyy-mm-dd'),'D')-1),'0','日','1','一','2','二','3','三','4','四','5','五','6','六' )
AS "日期",(TA.BEGINTIME || '-' || TA.ENDTIME) AS "时间", (TC.NAME || TA.CUSTOMIZEADDRESS) AS "地点",TA.NAME AS "会议内容",'非涉密' AS "会议密级" ,TD.LASTNAME AS "主持人"
,( SELECT LISTAGG(LASTNAME ,',') WITHIN GROUP(ORDER BY DEPARTMENTID,SECLEVEL DESC,DSPORDER) FROM MEETING_MEMBER2 NA,HRMRESOURCE NB,MEETING NC WHERE NC.ID=NA.MEETINGID AND NA.MEMBERID=NB.ID AND NC.ID=TA.ID AND NB.SECLEVEL>=10)
AS "参加领导和参加部门" ,TZBBMB.DEPARTMENTNAME AS "承办部门",TD.MOBILE AS "联系电话",TA.DESC_N AS "备注"
FROM (((((meeting TA left join MEETINGROOM TC on TA.ADDRESS=TC.ID) inner join meeting_type TB on TA.Meetingtype=TB.ID ) inner join HRMRESOURCE TD on TA.CALLER=TD.ID) inner join HRMDEPARTMENT TF on TF.ID=TD.DEPARTMENTID) inner join HRMRESOURCE TDZBBMH on TDZBBMH.ID=TA.CONTACTER) inner join HRMDEPARTMENT TZBBMB
on TDZBBMH.DEPARTMENTID=TZBBMB.ID where TB.HASLEADS=1
AND ( to_date(TA.BEGINDATE,'yyyy-mm-dd') BETWEEN trunc(to_date('${Date}','yyyy-mm-dd'),'iw') AND trunc(to_date('${Date}','yyyy-mm-dd'),'iw')+6) AND MEETINGSTATUS=2 AND CANCEL IS NULL
编辑于 2018-8-25 13:56
编辑于 2018-8-25 14:09
编辑于 2018-8-25 14:11
编辑于 2018-9-20 10:38
