在应收账龄分析表中会出现预收款的金额,那么在过滤设置“尚未收款金额>0”,过滤不出那些大于0的应收账款
设置“尚未收款金额(本位币)>0”时候,出现如下信息:
SELECT * INTO TMPF666B3345EB911E4B479000C293 FROM TMPF666B3335EB911E4B479000C293 WHERE (FBalanceAmt > 0)
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList)
at Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL)
at Kingdee.K3.FIN.AR.App.Report.AgingAnalysisService.BuilderReportSqlAndTempTable(IRptParams filter, String tableName)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetData(IRptParams filter)
at Kingdee.BOS.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()
at Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass33.
[u]请问能否过滤出大于0的数据?[/u]
另外,选项设置如下,想要显示两位小数,但是有些显示很多位小数,有些则不显示?
推荐阅读