SELECT

a.xh xh,

a.file_name file_name,

a.parentassetid parentassetid,

a.id,

a.page_num,

b.max,

b.min,

decode(

a.pageno,

b.max,

CONCAT( b.max - a.page_num + 1, '-', a.pageno ),

a.pageno

) page_num2

FROM

(

SELECT

*

FROM

da_custom262

WHERE

parentassetid IN(

'659282554477608960'

)

) a,

(

SELECT

parentassetid,

MIN( pageno ) MIN,

MAX( pageno + 0 ) MAX

FROM

(

SELECT

page_num,

pageno,

parentassetid

FROM

da_custom262

WHERE

parentassetid IN(

'659282554477608960'

)

)

GROUP BY

parentassetid

) b

WHERE

a.parentassetid = b.parentassetid

ORDER BY

a.xh

这个sql在报表设计器中直接写到数据集没问题，但是从后台传到报表服务时就报错，位置已经确认就是那个1附近，我还特意把1换成2试过，数据库是kingbase