This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / 求救！Crystal report！Group sum function.
在group 中已经计算了commission via formular， 客户要求在报告的最后一页提供总的commission。 可是 Sum function是虚的，不能用。Insert Summary, 可供选择的 data field 中，也没有commision, 怎么办呀？
-morningmaples(萤火虫);
2005-6-2
{216}
(#2326499@0)
-
应该有sum by group的选项，我以前遇到过不过忘了
-zhihaoxx()();
2005-6-2
(#2326537@0)
-
确定你的commission的类型是NUMBER, 如果是TEXT, 就不可以CALL SUM, 只能用MAX OR MIN etc.
-ivy_sh(失落的维京人);
2005-6-3
(#2326881@0)
-
I used formular: Sum ({@CAD equivlent}, {tmpReport.CUST_ID})* .001/365 * {@Days}, returned 是NUMBER, but
不可以CALL SUM, why?
-morningmaples(萤火虫);
2005-6-3
(#2327229@0)
-
Probably, you already had some aggregate function in your formulae. Normally, you cannot embed an aggregate function into another
-willington(居无定所);
2005-6-3
(#2327768@0)
-
download to excel, then you can get whatever you want.
-annran(ann);
2005-6-3
(#2327432@0)
-
还用formular.
-uvcare(uvcare);
2005-6-3
(#2327464@0)
-
You can always use "Running Total" for any kind of the summary
-willington(居无定所);
2005-6-3
(#2327750@0)
-
实在不行就做一个sub report来计算grand total.
-beatles(YellowSub);
2005-6-5
(#2330955@0)
-
Thanks for you guys kindly reply. However:
1) Expert to PDF format. 2) Checked all formular, it does not work
3) For running totals option, the formular which I set is not avaliable for select.Any other approach to recommend?
-morningmaples(萤火虫);
2005-6-7
{32}
(#2334020@0)