希望通过报表参数查询到单据
制单人——审核人——单据 显示数据
制单人 控件SQL
SELECT ov_untimecheck.sheet_type as 单据类型,
ov_untimecheck.sheet_name as 单据类型名称,
ov_untimecheck.sheet_kd as 模块,
ov_untimecheck.sheet_no as 单号,
ov_untimecheck.user_no as 制单人,
ov_untimecheck.audit_user as 审核人,
ov_untimecheck.create_date as 制单日期,
ov_untimecheck.audit_date as 审核日期,
ov_untimecheck.untime as 逾期处理时间,
ov_untimecheck.findtime as 查询时间,
ov_untimecheck.untime1 as 逾期未处理时间
FROM ov_untimecheck
where sheet_no='${单号}' and user_no='${制单人}' and audit_use='${审核人}'
审核人 控件SQL
SELECT ov_untimecheck.audit_user as 审核人
FROM ov_untimecheck
where user_no='${制单人}'
单号 控件SQL
SELECT ov_untimecheck.sheet_no
FROM ov_untimecheck
where ov_untimecheck.user_no='${制单人}' and ov_untimecheck.audit_user='${审核人}'
