水晶报表,报表页脚的基于组的摘要 [英] Crystal Report, Group based Summary at report footer
问题描述
HI,
是否可以在报告页尾显示群组摘要?让我解释一下场景。我必须创建以下类型的报告:
客户金额货币
客户123:
WWWW 300 SGD
XXXX 400 SGD
YYYY 200 USD
ZZZZ 300 USD
客户456:
W1W1 300 SGD
X1X1 400 SGD
Y1Y1 200 USD
Z1Z1 300 USD
。
。
。
。
。
在报表页尾,我需要显示以下内容:
总计:$ 1000
总计:SGD 1400
需要在报表页脚显示货币的总金额。可以在水晶报表中做?
除了Barry的解决方案之外,如果你知道
在评估部分中,单击公式并输入如下内容(对于例如美元货币)
{YourTableOrCommand.currency} =USD
摘要类型应为:总和
重置应为:从不 p>
这可能会给你一个不同的性能特点,然后有一个子报告,但你需要测试这个。
HI,
Is it possible to display summary of a group at the report footer ? Let me explain the scenario. I've to create the following kind of report:
Client Amount Currency Customer 123: WWWW 300 SGD XXXX 400 SGD YYYY 200 USD ZZZZ 300 USD Customer 456: W1W1 300 SGD X1X1 400 SGD Y1Y1 200 USD Z1Z1 300 USD . . . . .At the report footer, I need to show the following:
Grand total: USD 1000 Grand total: SGD 1400Need to display grand total of amount by Currency at Report footer.Is it possible to do in Crystal report? I'm using crystal report version 11. Could anyone suggest me a solution ?
解决方案An alternative to Barry's solution, if you know what currencies you're dealing with in advance, you could simply use a running total field for each currencly,
In the Evaluate section click formula and enter something like this (for the USD currency for instance)
{YourTableOrCommand.currency} = "USD"
Type of Summary should be: sum Reset should be: Never
This may give you a different performance characteristics then having a sub-report, but you'd need to test this.
这篇关于水晶报表,报表页脚的基于组的摘要的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!