SSRS报错 ERROR [42703] ERROR 2624
0
这是我的数据集查询表达式
="select pallet_id, pallet_create_dm,pn_id from MATS_ITG.pwax_pen_link where pallet_id in ("& Join(Parameters!pallet_id.Value,",") &")"
pallet_id是多值参数
查询的时候就报这样的错误
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DsPartial_lookup'. (rsErrorExecutingCommand)
ERROR [42703] ERROR 2624: Column "SGAC2207H0" does not exist
其中 SGAC2207H0是参数的一个值 ,不知哪里有问题,还请大神指教?
="select pallet_id, pallet_create_dm,pn_id from MATS_ITG.pwax_pen_link where pallet_id in ("& Join(Parameters!pallet_id.Value,",") &")"
pallet_id是多值参数
查询的时候就报这样的错误
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DsPartial_lookup'. (rsErrorExecutingCommand)
ERROR [42703] ERROR 2624: Column "SGAC2207H0" does not exist
其中 SGAC2207H0是参数的一个值 ,不知哪里有问题,还请大神指教?
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
1 个回复
天桥下的郑成功 - Hadoop大数据开发工程师、数仓架构师、熟悉数据仓库设计、Hadoop、Spark、HBase、Hive、SSIS等开发 2016-03-09 回答
赞同来自:
我建议你用SQLProfiler监视一下这个TSQL的执行,然后把语句拷贝出来看看哪里错了