sql从在报表设计器里预览没问题,但是从系统后台传给报表服务就会报这个错误sql:select a.*,b.max,decode(a.pageno,b.max,concat(concat(b.max-a.page_num+1,'-'),a.pageno),a.pageno) page_num2 FROM da_custom262 a join (select parentassetid,max(pageno+0) max FROM da_custom262 WHERE parentassetid in('659282554477608960','659282528913326080','657807616424017923','657807213024247810','657807213024247808','657807213024247812','657807213024247809','657807213024247811','657570118015909888','657808051436257284','657808051436257283','657808051436257282','657808051436257281','657808051436257280','656783716747575296','656783673336528896','656783669200945152','656782911512510464','657807125057110016','657807125057110018') GROUP BY parentassetid) b on a.parentassetid = b.parentassetid WHERE 1=1 AND a.del_tag = 0 AND a.statusbt = 0