点击超级链接有多条记录会这样报错，如果是单条记录则不报错，这是什么问题，需要怎么修改

SELECT *,

CONCAT(ZRDATE, ',', zrequester_id, ',', ZPROD_TYPE) AS ZLONG

FROM loan_list

WHERE 1 = 1

/*AND zrdate >= '${startdate}'

AND zrdate <= '${enddate}'*/

AND LEFT(zrdate, 10) >= '${startdate}' and LEFT(zrdate, 10) <='${enddate}'

AND zdel_flag IS NULL -- 新增的条件，只查询zdel_flag为空的记录

FineReport nesy 发布于 2025-5-9 09:09 （编辑于 2025-5-9 09:11）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共3回答

CD20160914Lv8专家互助
发布于2025-5-9 09:12（编辑于 2025-5-9 09:25）

那你接收的报表中要用 字段名称 in ('${参数名称}')

而且单元格的格式要形成类似 AA','BB

这样的格式！

SELECT *

FROM loan_list

WHERE 1 = 1

AND zdel_flag IS NULL

${if(len(ZLONG) == 0,""," AND CONCAT(ZRDATE,',',zrequester_id,',',ZPROD_TYPE) = '" + ZLONG + "'")}

${if(len(zrequester_id) == 0,""," AND zrequester_id = '" + zrequester_id + "'")}

${if(len(zprod_type) == 0,""," AND zprod_type = '" + zprod_type + "'")}

${if(len(申请日期) == 0,""," AND DATE(zrdate) = '" + 申请日期 + "'")}

${if(len(zid) == 0,""," AND zid in('" + zid + "')")}

举报收起评论(6)

nesy(提问者) SELECT *
FROM loan_list
WHERE 1 = 1
AND zdel_flag IS NULL
${if(len(ZLONG) == 0,""," AND CONCAT(ZRDATE,',',zrequester_id,',',ZPROD_TYPE) = '" + ZLONG + "'")}
${if(len(zrequester_id) == 0,""," AND zrequester_id = '" + zrequester_id + "'")}
${if(len(zprod_type) == 0,""," AND zprod_type = '" + zprod_type + "'")}
${if(len(申请日期) == 0,""," AND DATE(zrdate) = '" + 申请日期 + "'")}
${if(len(zid) == 0,""," AND zid = '" + zid + "'")}
ORDER BY ZRDATE, zrequester_id, ZID这是超级链接报表的数据集

2025-05-09 09:24