旗舰版6.0 BOS平台制作表单

SELECT tH.FBillNo AS '单据编号',t1.FName AS '客户'
,tH.FText1 AS '品类'
,SUM(tH.FAmount) AS '上账金额'
,SUM(tG.FAmount) AS '使用金额'
,SUM(tH.FAmount )-SUM(tG.FAmount) AS '未使用金额'
FROM tH,tG, t_Organization t1
WHERE tH.FBase2 = tG.FBase2
AND tG.FBase2 = t1.FItemID
AND tH.FDate>='********'
AND tH.FDate<='########'
OR (t1.FNumber>= '*CustNo*'
AND t1.FNumber<= '#CustNo#')

GROUP BY t1.FName
,tH.FBillNo
,tH.Fdate
,tG.Fdate
,tH.FText1

UNION ALL

SELECT '合计' AS '单据编号'
,'' AS '客户'
,'' AS '品类'
,SUM(tH.FAmount ) AS '上账金额'
,SUM(tG.FAmount) AS '使用金额'
,SUM(tH.FAmount )-SUM(tG.FAmount) AS '未使用金额'
FROM tH,tG, t_Organization t1
WHERE tH.FBase2 = tG.FBase2
AND tG.FBase2 = t1.FItemID
AND tH.FDate>='********'
AND tH.FDate<='########'
OR t1.FNumber>= '*CustNo*'
AND t1.FNumber<= '#CustNO#'
旗舰版6.0环境打过一个PT129084的补丁