在SQL里查询正常，但发布的时候报错。调用的是存储过程，具体语法如下：
存储过程脚本如下：

IF OBJECT_ID (N'dbo.CP_YK_SALRECOST') IS NOT NULL

DROP PROCEDURE dbo.CP_YK_SALRECOST

CREATE PROCEDURE CP_YK_SALRECOST

@FYEAR int,

@FPERIOD int

SELECT top 5000 *

into #tmpSalCost

FROM (

SELECT t0.FREDBLUE fredblue, t0_O.FINFOTABLENUMBER finfotablenumber, t1.FOPENQTY fopenqty_d, t0.FAFTERTOTALTAXFOR faftertotaltaxfor, t0.FBILLNO fbillno, t0.FBILLTYPEID fbilltypeid, t0.FDATE fdate,

t0.FCUSTOMERID fcustomerid_id, t0_O.FIVCUSTOMERID fivcustomerid_id, t0.FCURRENCYID fcurrencyid_id, t0.FDOCUMENTSTATUS fdocumentstatus, t0.FBILLINGWAY fbillingway, t0.FINVOICENO finvoiceno, t0.FINVOICEDATE finvoicedate,

t0.FSETTLEORGID fsettleorgid_id, t0.FSALEORGID fsaleorgid_id, t0_O.FSOURCEIVCODE fsourceivcode, t0.FACCOUNTSYSTEM faccountsystem_id, t0.FOPENSTATUS fopenstatus, t0_O.FSOURCEIVNUMBER fsourceivnumber, t0.FISTAX fistax,

t0.FSETTLETYPEID fsettletypeid_id, t0.FMAINBOOKSTDCURRID fmainbookstdcurrid_id, t0.FEXCHANGETYPE fexchangetype_id, t0.FAFTERTOTALTAX faftertotaltax, t0.FSALEDEPTID fsaledeptid_id, t0.FEXCHANGERATE fexchangerate,

t0.FSALEGROUPID fsalegroupid_id, t0.FTAXAMOUNTFOR ftaxamountfor, t0.FSALEERID fsaleerid_id, t0.FTAXAMOUNT ftaxamount, t0.FAUXPRICEFOR fheadauxpricefor, t0.FCREATORID fcreatorid_id, t0.FAUXPRICE fheadauxprice,

t0.FCREATEDATE fcreatedate, t0.FMODIFIERID fmodifierid_id, t0_O.FIVCODE fivcode, t0.FAPPROVERID fapproverid_id, t0.FMODIFYDATE fmodifydate, t0_O.FIVNUMBER fivnumber, t0.FAPPROVEDATE fapprovedate, t0.FCANCELSTATUS

fcancelstatus, t1.FSRCBILLNO fsrcbillno, t1.FSRCBILLTYPEID fsrcbilltypeid, t1.FMATERIALID fmaterialid_id, t2.FNUMBER fmaterialnumber,

t1_L.FMATERIALDESC fmaterialdesc, t1.FAUXPRICE fauxprice, t1.FAUXTAXPRICE fauxtaxprice, t1.FPRICEUNITID

fpriceunitid_id, t1.FPRICEQTY fpriceqty, t1.FAMOUNTFOR famountfor, t1.FTAXRATE ftaxrate, t1.FDETAILTAXAMOUNTFOR fdetailtaxamountfor, t1.FALLAMOUNTFOR fallamountfor, t1.FPUSHREDQTY fpushredqty, t1.FSALESORDERNO

fsalesorderno, t1.FCOMMENT fcomment, t1.FBASICUNITID fbasicunitid_id, t1.FBASICUNITQTY fbasicunitqty, t1.FOPENSTATUS fopenstatus_d, t1.FOPENAMOUNTFOR fopenamountfor_d, t0.FEXPORTCOUNT fexportcount, t0.FSERIALNUMBER

fserialnumber, t0.FINVOICETITLE finvoicetitle, t0.FTAXREGISTERCODE ftaxregistercode, t0.FISB2C fisb2c, t0.FOPENBANKNAME fopenbankname, t0.FCANCELLERID fcancellerid_id, t0.FBANKCODE fbankcode, t0.FCANCELDATE fcanceldate,

t0.FTEL ftel, t0.FADDRESS faddress, t0_O.FGTSTATUS fgtstatus, t0_O.FGTPRINTCOUNT fgtprintcount, t0_O.FGTPRINTLISTCOUNT fgtprintlistcount, t1_O.FAUXPROPID fauxpropid, t1_O.FLOT flot_id, t1.FENTRYDISCOUNTRATE fentrydiscountrate, t1.FDISCOUNTAMOUNTFOR fdiscountamountfor, t1_O.FDISCOUNTAMOUNT fdiscountamount, t1_O.FDETAILTAXAMOUNT fdetailtaxamount, t1_O.FNOTAXAMOUNT fnotaxamount, t1_O.FALLAMOUNT fallamount, t1.FCOSTAMTSUM fcostamtsum, t0_O.FHAVEIVLIST fhaveivlist, t0_O.FSOURCESERIALNUM fsourceserialnum, t0_O.FDRAWER fdrawer, t0_O.FPAYEE fpayee, t0_O.FGTDISKNUMBER fgtdisknumber, t1.FDEDUCTION fdeduction, t0_O.FREVIEWER freviewer, t1.FTAXDEDUCTION ftaxdeduction, t0_O.FGETCOSTLASTEDDATE fgetcostlasteddate, t0_O.FCOSTCALDATE fcostcaldate, t0_O.FSCANPOINT fscanpoint_id, t0.FISHOOKMATCH fishookmatch, t0_O.FARCHIVENO farchiveno, t1.FCUSTMATID fcustmatid_id, t0_O.FCHECKCODE fcheckcode, t0.F_ORA_BASE f_ora_base_id, t1.F_YK_OUTBOUND f_yk_outbound, t1.F_YK_RECEIVABLE f_yk_receivable, st1_O1.FOPCODE fauxpropid_1, t0.FSETTLEORGID fsettleorgid, t0.FFORMID fformid, t0.FID fid, t1.FENTRYID t1_fentryid, t1.FSEQ t1_fseq, ROW_NUMBER() OVER( ORDER BY t0.FCREATEDATE DESC, t1.FENTRYID ASC) fidentityid

FROM T_IV_SALESIC t0

LEFT OUTER JOIN T_IV_SALESIC_O t0_O ON t0.FID = t0_O.FID

LEFT OUTER JOIN T_IV_SALESICENTRY t1 ON t0.FID = t1.FID

INNER JOIN T_BD_MATERIAL t2 ON t1.FMATERIALID=t2.FMATERIALID

LEFT OUTER JOIN T_IV_SALESICENTRY_O t1_O ON t1.FENTRYID = t1_O.FENTRYID

LEFT OUTER JOIN T_IV_SALESICENTRY_L t1_L ON (t1.FENTRYID = t1_L.FENTRYID AND t1_L.FLocaleId = 2052)

LEFT OUTER JOIN T_BD_FLEXSITEMDETAILV st1_O1 ON t1_O.FAUXPROPID = st1_O1.FID

WHERE ((((YEAR(t0.FDATE) = @FYEAR) AND ((MONTH(t0.FDATE)=@FPERIOD)))

AND t0.FSETTLEORGID IN (1, 100029, 100030, 100031, 100032)) AND (t0.FSETTLEORGID IN (100029, 0)

AND t0.FFORMID = 'IV_SALESIC'))) tlist

WHERE ((fidentityid >= 1) AND (fidentityid <= 10000))

SELECT f_yk_outbound AS 'SALES OUTBOUND', fdate AS 'INV DATE',year(fdate) as 'YEAR',MONTH(fdate) AS 'MONTH',

fbillno AS 'INV NUMBER',finvoicetitle AS 'CLIENT','Ganzhou' AS DESTINATION,fsalesorderno AS 'PO',

fmaterialnumber AS 'MATCODE',fmaterialdesc AS LIGHTER,'' AS PRESENTATION, fpriceqty AS 'QTY(CARTON)',

'人民币' AS CURR,fauxprice AS 'UNIT PRICE', famountfor AS 'TTL AMOUNT', fexchangerate AS 'EXCHANGE RATE',

fallamount AS 'TTL RMB',fdrawer AS SALESMAN,'' AS 'VOUCHER NO',fcostamtsum AS 'COST OF SOLD'

FROM #tmpSalCost

--- select * from #tmpSalCost

--- exec CP_YK_SALRECOST 2020,8

DROP TABLE #tmpSalCost

-------------------------------

直接sql语法如下：

exec CP_YK_SALRECOST #FYear#,#FPeriod#

验证报错如下：

在应用中的报错信息如下：

错误ID：7C98360EBBE635839922C9C2F470C658

[{"operation":"kf1a7db6d0b0e4044a30c9f659a14490f.GetReportData"}]

发生时间： 18:16:23

错误编号： a79b011a218c457d94f3501612132501

错误信息： Syntax error in aggregate argument: Expecting a single column argument with possible 'Child' qualifier.

===================================================

调用堆栈：

at System.Data.ExpressionParser.ParseAggregateArgument(FunctionId aggregate)

at System.Data.ExpressionParser.Parse()

at System.Data.DataExpression..ctor(DataTable table, String expression, Type type)

at System.Data.DataTable.Compute(String expression, String filter)

at Kingdee.BOS.Web.Report.SQLReport.SQLReportView.GetFieldSummary(DecimalField decimalField, ListHeader listHeader, DataTable summaryDataTable)

at Kingdee.BOS.Web.Report.SQLReport.SQLReportView.GetSummaryData(List`1 summaryFields, List`1 listHeaders)

at Kingdee.BOS.Web.Report.SQLReport.SQLReportView.GetData(Int32 startRow, Int32 limit)

at Kingdee.BOS.Web.Report.SQLReport.SQLReportController.GetReportData(

以上为主要信息，烦请总部的专家予以解答一下，谢谢！

产品问题直接sql有表发布后运行报错

产品问题 直接sql有表发布后运行报错

恭喜您！

产品问题
直接sql有表发布后运行报错

产品问题直接sql有表发布后运行报错