|
0
|
用户k6280494Lv6专家互助发布于3 天前
|
|
|
-
帆软用户PoN24uZLlw(提问者)
- set nocount on
EXEC tb_spi_GetProductionList
@weekly2 = ${weekly2},
@rfq = ${rfq},
@huilv = ${huilv},
@productionno = ${if(len(productionno) == 0, "NULL", "'" + productionno + "'")},
@productionname = ${if(len(productionname) == 0, "NULL", "'" + productionname + "'")},
@category = ${if(len(category) == 0, "NULL", "'" + category + "'")}
set nocount off
-
用户k6280494 回复 帆软用户PoN24uZLlw(提问者)
- 数据集不支持这种写法哦 做成存储过程吧
-
用户k6280494 回复 帆软用户PoN24uZLlw(提问者)
- https://help.fanruan.com/finereport/doc-view-117.html
|
|
|
0
|
CD20160914Lv8专家互助发布于3 天前
|
你现在的参数是如何的，你如何传的参数。完整的sql发出来。是什么数据库？传的值是什么 |
-
帆软用户PoN24uZLlw(提问者)
- set nocount on
EXEC tb_spi_GetProductionList
@weekly2 = ${weekly2},
@rfq = ${rfq},
@huilv = ${huilv},
@productionno = ${if(len(productionno) == 0, "NULL", "'" + productionno + "'")},
@productionname = ${if(len(productionname) == 0, "NULL", "'" + productionname + "'")},
@category = ${if(len(category) == 0, "NULL", "'" + category + "'")}
set nocount off
-
帆软用户PoN24uZLlw(提问者)
- 数据集预览是可以的，但是cpt文件预览就报错
-
CD20160914 回复 帆软用户PoN24uZLlw(提问者)
- 写存储吧，然后调用存储过程了。
|
|
1min目标场景问卷
立即参与
