我从下面设计了一个水晶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! :)
更多推荐
我想在水晶报表中计算总数
发布评论