【搞定】有关数据集策略的问题[请求]**

chaoqiang

在一个部门里头，增加一个数据集策略，运行功能后，提示如附件的问题，请要怎么解决？

chaoqiang

我是通过如下语句传入参数
with DataSetBrokerTM_sdsDateReport.DataSet do
  begin
    close;
    Params.ParamByName('BeginDate').value:=DateTimePicker1.Date;
    Params.ParamByName('EndDate').value:=DateTimePicker2.Date;
    open;
  end;

chaoqiang

数据集里头参数属性的设置如下图

lisb

跟参数应该没关系，你的sql语句执行没问题吧，你把数据集的sql语句再加上你在数据集策略中施加的范围条件拼起来拿到外边执行一下看看报不报错。

chaoqiang

没有加策略，执行起来是没有问题的，你说的办法我马上试看看

chaoqiang

我直接把策略里的条件作为数据集sql语句的where，执行起来是可以的。整个语句如下
select A.SALESDEPT,A.FREIGHT,A.BACK,A.SMALL,A.SAMPLE,A.ADJUST,A.SALES,A.RETURN,A.INVOICE
from

(SELECT
SALESDEPT,

SUM(CASE WHEN FREIGHTTYPE='正常出货' THEN MONEYSUM ELSE 0 END) AS FREIGHT,

SUM(CASE WHEN FREIGHTTYPE='正常退货' THEN MONEYSUM ELSE 0 END) AS BACK,

SUM(CASE WHEN FREIGHTTYPE='小缸费' THEN MONEYSUM ELSE 0 END) AS SMALL,

SUM(CASE WHEN FREIGHTTYPE='打样费' THEN MONEYSUM ELSE 0 END) AS SAMPLE,

SUM(CASE WHEN FREIGHTTYPE='数量调整' THEN MONEYSUM ELSE 0 END) +
SUM(CASE WHEN FREIGHTTYPE='金额调整' THEN MONEYSUM ELSE 0 END)  AS ADJUST,

SUM(MONEYSUM) AS SALES,

SUM(HAVERETURN) AS RETURN,

SUM(HAVEINVOICED) AS INVOICE

FROM
(
SELECT TM_FREIGHTSUB.PKID,TM_FREIGHTSUB.FREIGHTTYPE, TM_FREIGHTSUB.MONEYSUM, CHECKSUB.HAVERETURN, CHECKSUB.HAVEINVOICED, TM_FREIGHTMAIN.SALESDEPT,TM_FREIGHTMAIN.FREIGHTDATE
FROM TM_FREIGHTMAIN,TM_FREIGHTSUB,CHECKSUB where TM_FREIGHTSUB.UPPERID = TM_FREIGHTMAIN.PKID(+) and TM_FREIGHTSUB.PKID=CHECKSUB.FREIGHTPKID(+)
AND TM_FREIGHTMAIN.FREIGHTDATE between :BeginDate and :EndDate
)

GROUP BY SALESDEPT

) A
where A.SALESDEPT = &[Biz:\SYSTEM\ORGPARAMS.PARAMGROUP\DeptID.Param]

chaoqiang

为什么在策略里头就不行了，我该怎么处理？

lisb

不应该啊，你把你的资源打一下包传上来我看一下吧。

chaoqiang

需要打资源包干吗？ 你难道要我把我们的组织也给你么？
你们的策略条件不是直接作为where语句加在sql后面的么？

lisb

是啊，我这里重现不出来，不传包怎么解决你的问题，组织机构不需要，只要功能，信息、表就行了