1、使用查询查询分析自定义报表,定义查询分析关键字,用于设置关联信息,注意字段类型
2、配置关联信息
以下以销售订单关联产品入库举例整个配置过程:
因为内置产品入库无法直接关联。
create view xn_stock_cinasSELECT t.FDate 入库日期,t.FBillNo 入库单号,t3.FName 交货部门, t.FEntryID 行号,soid,seq ,t2.fnumber 产品代码,t2.fname 产品名称,t2.fmodel 规格型号,t.fbatchno 批次, FAuxQty 入库数量,t4.fname 仓库FROM (SELECT a.fdate, a.fbillno,b.fentryid, b.fsourceinterid soid,b.FSourceEntryID seq,b.fauxqty,a.FDeptID ,b.FDCStockID,b.FItemID ,FBatchNoFROM icstockbill a INNER JOIN icstockbillentry b ON a.finterid = b.finterid WHERE 1=1 AND a.ftrantype = 2 AND b.FSourceTranType =81 AND ISNULL(a.fcheckerid,0)>0UNION SELECT a.fdate,a.fbillno,b.fentryid, c.forderinterid soid,c.FSourceEntryID seq,b.fauxqty,a.FDeptID,b.FDCStockID,b.FItemID ,FBatchNoFROM icstockbill a INNER JOIN icstockbillentry b ON a.finterid = b.finterid inner JOIN icmo c ON b.fsourceinterid =c.finterid AND b.FSourceTranType =85 and b.fitemid = c.fitemidWHERE 1=1 AND a.ftrantype = 2 AND b.FSourceTranType =85 AND ISNULL(a.fcheckerid,0)>0)t left join t_ICItem t2 on t.FItemID = t2.FItemID left join t_Department t3 on t.FDeptID = t3.FItemID left join t_Stock t4 on t.FDCStockID = t4.FItemID WHERE 1=1--soid = '@finterid@' AND seq = '@fentryid@'
SELECT 1 fsumsort, * FROM xn_stock_cinWHERE soid = '@finterid@' AND seq = '@fentryid@'union SELECT 103 fsumsort, null 入库日期,'合计' 入库单号,null 交货部门, null 行号,null soid, null seq ,null 产品代码,null 产品名称,null 规格型号,null 批次,sum(入库数量) 入库数量,null 仓库 FROM xn_stock_cinWHERE soid = '@finterid@' AND seq = '@fentryid@'ORDER BY fsumsort,入库日期,soid,seq
在右侧对应字段设置中,按下图配置,并确定。
<完>
声明:原创文章,转载请注明出处!
联系客服