我想在水晶报表中计算总数 [英] I want to calculate the total in crystal report

问题描述

我从下面设计了一个水晶reprot我想计算水晶报表中的SUB TOTAL和Grand Total如何操作.请帮帮我.

注意:SUB TOTAL和总计总计不在数据库中

SNO Partiuclars金额


1抵押费用231270

2服务费19767

小计251037


3服务税30124

4 Edu Cess 2％602

5添加Cess 1％301


总计282064

i design a crystal reprot from the below i want to calculate the SUB TOTAL and Grand Total in crystal report how to do.please help me.

Note: SUB TOTAL and Grand Total not in DATABASE

SNO Partiuclars Amount


1 Aminities Charges 231270

2 Service Charges 19767

SUB TOTAL 251037


3 Service Tax 30124

4 Edu Cess 2% 602

5 Add Cess 1% 301


GRAND TOTAL 282064

推荐答案

总计很容易
只需获取金额"字段的摘要并将其粘贴到报告页脚/所需的组页脚中

小计需要努力，
您必须创建一个公式字段，以在srno小于3时进行加法运算
在详细信息部分下面创建新部分，并将此公式字段放在此新部分中，如果srno不等于2，则取消显示该新部分.
注意:如果页面只有一页，那么只有一个公式会创建公式，将新凭证/页面重置为零

祝您编码愉快！
:)

grand total is easy
just take summary of Amount field and paste it in report footer / desired group footer

sub total will need effort,
you have to create formula field that do addition of amount when srno is less than 3
create new section below detail section and put this formula field in this new section and suppress that new section if srno is not = 2
Note: if it''s only one page then only one formula else also create formula that reset it to zero for new voucher/page what ever

Happy Coding!
:)

这篇关于我想在水晶报表中计算总数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！