Chart Sum can't show
hi everyone:
I want to use chartobject show sum data,but It can't show anything.
I write the SQL in SQLserver2000's pub database:
Select
sales.stor_id,
sales.ord_num,
sales.ord_date,
sales.qty,
sales.payterms,
sales.title_id
FROM sales
now, x value is set MasterDS."stor_id", Y value is set
SUM(<MasterDS."qty">,MasterData1)
I know if use "group by" can impl,but I hope show all data,how to resolve?
I want to use chartobject show sum data,but It can't show anything.
I write the SQL in SQLserver2000's pub database:
Select
sales.stor_id,
sales.ord_num,
sales.ord_date,
sales.qty,
sales.payterms,
sales.title_id
FROM sales
now, x value is set MasterDS."stor_id", Y value is set
SUM(<MasterDS."qty">,MasterData1)
I know if use "group by" can impl,but I hope show all data,how to resolve?
Comments
I've got the same problem..