2013年7月31日
SSRS奇怪报错Could not update a list of fields for the quer.
摘要： 今天遇到一个奇怪的问题，SSRS我觉得是个半成品，很多东西都搞不了。写了一段SQL，本来SQL写法都有点怪了，如下WITH TMP_A AS (SELECT *,ROW_NUMBER() OVER(PARTITION BY L1_WorkOrderType,L2_TaskCode ORDER BY L4_QTY)CC FROM(SELECTB.B1_APP_TYPE_ALIAS AS L1_WorkOrderType,WO.TASK_CODE AS L2_TaskCode,WO.COST_ITEM AS L3_CostItem,SUM(WO.COST_QUANTITY) AS L4_QTY,M 阅读全文
posted @ 2013-07-31 17:45 medci(卡樂江) 阅读(443) 评论(0) 推荐(0)