Crystal报表中的页面总和 [英] Page sum in Crystal report
问题描述
我想在页脚中计算页数并在下一个报告中显示相同金额
即我的栏目金额看起来像
in page1
金额
-----------------
1
2
5
6
---
总和:14
第2页
金额
---- ---------
b / F:14
-----
10
6
10
----
总和:40
我试过这个在
allsumFormula:WhilePrintingRecords;
共享numberVar totalsetPum;
共享numberVar totalPiecesPSum;
共享numberVar totalAmountPSum;
totalsetPsum:= totalsetPsum + {sp_report_select_view_madeup_shipping_instruction_details; 1.totalsetreg}; totalPiecesPSum:= totalPiecesPSum + {sp_report_select_view_madeup_shipping_instruction_details; 1.totalpcsreg}; totalAmountPSum:= totalAmountPSum + {sp_report_select_view_madeup_shipping_instruction_details; 1.value};
in
sumheadder:WhilePrintingRecords;
共享numberVar totalsetPum;如果PageNumber<> 1则为totalsetPsum- {sp_report_select_view_madeup_shipping_instruction_details; 1.totalsetreg};
但在奇数页和偶数页中它们给出不同的值
Iwant to calculate page sum in page footer and show same amount in next report headder
ie My column Amount look like
in page1
Amount
-----------------
1
2
5
6
---
sum:14
page 2
Amount
-------------
b/F:14
-----
10
6
10
----
sum:40
iam tried this in
allsumFormula: WhilePrintingRecords ;
shared numberVar totalsetPsum;
shared numberVar totalPiecesPSum;
shared numberVar totalAmountPSum;
totalsetPsum:=totalsetPsum+{sp_report_select_view_madeup_shipping_instruction_details;1.totalsetreg}; totalPiecesPSum:=totalPiecesPSum+{sp_report_select_view_madeup_shipping_instruction_details;1.totalpcsreg}; totalAmountPSum:=totalAmountPSum+{sp_report_select_view_madeup_shipping_instruction_details;1.value};
in
sumheadder: WhilePrintingRecords ;
shared numberVar totalsetPsum; if PageNumber <>1 then totalsetPsum-{sp_report_select_view_madeup_shipping_instruction_details;1.totalsetreg};
but in odd and even pages they give different value
推荐答案
如果我理解你的问题,你实际需要的只是修改外观您的公式(抑制或不抑制)不是计算本身,所以在您的最后一个公式中它应该是这样的
If I Understand your question well , all you need actually is modify the appearance of your formula (suppress or not suppress) not the calculation itself, so that at your last formula it should be like that
WhilePrintingRecords ;
shared numberVar totalsetPsum;
totalsetPsum-{sp_report_select_view_madeup_shipping_instruction_details;1.totalsetreg};
之后您将需要打开格式化公式
右键单击公式 - >选择格式字段 - >从出现的格式编辑器窗口中选择Common选项卡 - >在Suppress CheckBox旁边有一个公式按钮,用于控制何时按下它并按下它并添加此行
after that you will need to open format formula like that
right click the formula -> choose Format field -> from the format editor window that appears select Common tab -> beside Suppress CheckBox there's formula button that controls when to suppress it press it and add this line
if PageNumber = 1 then true else false
它应该为你做的不影响任何计算。
it should do the trick for you without affecting any calculation.
这篇关于Crystal报表中的页面总和的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!