0
|
snrtuemcLv8专家互助发布于2024-8-12 10:22
|
这个检查是不是报表传递参数不对导致,看看参数传递了什么,
|
-
Lllll(提问者)
- 就是传参了一下日期,
${IF( ( (LEFT ( p_mon1 , 6)- LEFT ( p_mon , 6) = 1 || LEFT ( p_mon1 , 6)- LEFT ( p_mon , 6) = 89) && RIGHT (p_mon1 , 2) '20'),
" AND A.YEAR_MONTH = left ( '"+p_mon1+ "',6)" ,
IF(LEFT ( p_mon1 , 6)- LEFT ( p_mon , 6) = 0 ,
if(RIGHT (p_mon1 , 2) '20'," AND TO_CHAR( to_date( A.YEAR_MONTH,'YYYYMM') - 1 month , 'YYYYMM') = left ( '"+p_mon1+ "',6)","AND 1 != 1")),"AND 1 != 1"))}
-
snrtuemc 回复 Lllll(提问者)
- RIGHT (p_mon1 , 2) '20'这个不对,例如改成 RIGHT (p_mon1 , 2)='20'
|
|