妈的,气死我了。金蝶的万能报表太太太太太破了~不同视图里面的同样一个字段,竟然被万能报表定义为不同的数据类型!!!搞到没有办法关联!!只能通过写SQL语句定义关联??这样一来就不可以使用系统定义条件查询了!现在我还要教财务在查询REPORT的时候自己修改SQL语句,真郁闷死了……
写软件的人不敬业,害死多少人呐。
强烈鄙视一下!
附:K/3商业版销售利润表查询语句
SELECT
([销售发票视图].[FDueStatusName]) AS [核销状态],
([销售发票视图].[FExplanation]) AS [摘要],
([销售发票视图].[FPreparerName]) AS [制单人姓名],
([销售发票视图].[FSaleTypeName]) AS [销售方式],
([销售发票视图].[FVoucherNumber]) AS [凭证号],
(([销售发票视图].[FAmt]-([销售出库单视图].[FUNITCOST]*[销售发票视图].[FQty]))/[销售发票视图].[FAmt]) AS [毛利率],
([销售发票视图].[FAmt]-([销售出库单视图].[FUNITCOST]*[销售发票视图].[FQty])) AS [毛利],
([销售出库单视图].[FUNITCOST]) AS [单位成本],
([销售出库单视图].[FUNITCOST]*[销售发票视图].[FQty]) AS [成本],
([销售发票视图].[FAmt]) AS [金额],
([销售发票视图].[FPrice]) AS [单价],
([销售发票视图].[FQty]) AS [数量],
([销售发票视图].[fbatchno]) AS [批次号],
([销售发票视图].[FModel]) AS [规格型号],
([销售发票视图].[FItemName]) AS [商品名称],
([销售发票视图].[FItemNumber]) AS [商品代码],
([销售发票视图].[FEmpName]) AS [业务员名称],
([销售发票视图].[FEmpNumber]) AS [业务员代码],
([销售发票视图].[FCustomerName]) AS [客户名称],
([销售发票视图].[FCustomerNumber]) AS [客户代码],
([销售发票视图].[FBILLID]) AS [发票号],
([销售发票视图].[FDateBusiness]) AS [业务日期],
([销售发票视图].[FPeriod]) AS [期间],
([销售发票视图].[FYear]) AS [年份]
FROM
(([VW_COM_InvSale_More] AS [销售发票视图] INNER JOIN [COM_LinkInvSend] AS [销售发票勾对表] ON [销售发票视图].[FEntryID]=[销售发票勾对表].[FEntryID] AND [销售发票视图].[FID]=[销售发票勾对表].[FID]) INNER JOIN [COM_LinkSend] AS [销售出库单勾对表] ON [销售发票勾对表].[FLinkID]=[销售出库单勾对表].[FLinkID] AND [销售发票勾对表].[FEntryID]=[销售出库单勾对表].[FEntryID]) INNER JOIN [VW_COM_SaleInOut_More] AS [销售出库单视图] ON [销售出库单勾对表].[FEntryID]=[销售出库单视图].[FENTRYID] AND [销售出库单勾对表].[FID]=[销售出库单视图].[FID] AND [销售发票视图].[Fbatchno]=[销售出库单视图].[Fbatchno]
WHERE
[销售发票视图].[FYear] =2005 And [销售发票视图].[FPeriod] =9
ORDER BY
([销售发票视图].[FPeriod]) ASC,
([销售发票视图].[FCustomerName]) ASC,
([销售发票视图].[FItemName]) ASC,
([销售发票视图].[FModel]) ASC,
([销售发票视图].[fbatchno]) ASC