我现有一表名为: product,字段内容如下:
productID productName price num
001 商品1 2.15 2
002 商品2 5.5 5
003 商品3 4.15 8
001 商品1 2.15 5现我想在DBGrid 中显示出
产品号 产品名 单价 数量 小计
001 商品1 2.15 7 15.05
002 商品2 5.5 5 27.5
003 商品3 4.15 8 33.2请问如何实现呢?而且在报表中打印也如上相试,请求解法,在线等....
productID productName price num
001 商品1 2.15 2
002 商品2 5.5 5
003 商品3 4.15 8
001 商品1 2.15 5现我想在DBGrid 中显示出
产品号 产品名 单价 数量 小计
001 商品1 2.15 7 15.05
002 商品2 5.5 5 27.5
003 商品3 4.15 8 33.2请问如何实现呢?而且在报表中打印也如上相试,请求解法,在线等....
from product
from product
group by productID,productName,price
order by productID
from product
group by productID
order by productID
from product group by productid,productname
我现有一表名为: product,字段内容如下:
productID productName price num
001 商品1 2.15 2
002 商品2 5.5 5
003 商品3 4.15 8
001 商品1 2.15 5一个表为table2
code name fyprice fynum
aaa 物品1 5 2
bbb 物品2 4 5
ccc 物品3 8 8
aaa 物品1 5 5我现在要求在报表中显示打印为
产品号 产品名 单价 数量 小计
001 商品1 2.15 7 15.05
002 商品2 5.5 5 27.5
003 商品3 4.15 8 33.2
aaa 物品1 5 7 35
bbb 物品2 4 5 20
ccc 物品3 8 8 64请问如何在报表中显示并打印呀。
解决后结帖。
谢谢!
'(select productID as 产品号,productName as 产品名,price as 单价,sum(num) as 数量, price * Sum(num) as 小计
from product
group by productID)
union
(select code as 产品号,name as 产品名,fyprice as 单价,sum(fynum) as 数量, fyprice * Sum(fynum) as 小计
from table2
group by code)'
QREPORT页中的TQRDBText控件Dataset设为Query1,DataField分别设为“产品号”“产品名”“单价”“数量 ”“小计”
select productID as 产品号,productName as 产品名,price as 单价,sum(num) as 数量, price * Sum(num) as 小计
from product
group by productID总是提示说一些字段"在选择列表中无效,因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中。"
price * SUM(num) AS 小计
FROM product
GROUP BY productID, productName, price
UNION
SELECT code AS 产品号, name AS 产品名, fyprice AS 单价, SUM(fynum) AS 数量,
fyprice * SUM(fynum) AS 小计
FROM table2
GROUP BY code, name, fyprice
如 base
id text
001 001A
002 002A
003 003A
aaa aaaA
bbb bbbA
ccc cccA
怎么样显示为下呢?
产品号 产品名 单价 数量 小计 text
001 商品1 2.15 7 15.05 001A
002 商品2 5.5 5 27.5 002A
003 商品3 4.15 8 33.2 003A
aaa 物品1 5 7 35 aaaA
bbb 物品2 4 5 20 bbbA
ccc 物品3 8 8 64 cccA
FROM (SELECT productID AS 产品号, productName AS 产品名, price AS 单价, SUM(num)
AS 数量, price * SUM(num) AS 小计
FROM product
GROUP BY productID, productName, price
UNION
SELECT code AS 产品号, name AS 产品名, fyprice AS 单价, SUM(fynum) AS 数
量, fyprice * SUM(fynum) AS 小计
FROM table2
GROUP BY code, name, fyprice) a INNER JOIN
base b ON a.产品号 = b.id