Crystal Report公式计算信用卡和借记卡的余额 [英] Crystal Report formula to Calculate Balance from Credit and Debit

问题描述

hi,


In my web Application i have showing report for "Customer Ledger"

Here i need to display report as follows...

BillNo|Credit | Debit  | Balance
--------------------------------------
B0982 | 1000  |    0   |   -1000
B0999 | 2000  |    0   |   -3000
B0982 |  0    |  2200  |   -800
B1200 | 5000  |    0   |   -5800


Likewise i need to Calculate my <b>"BALANCE".</b>

I have populate credit and debit from the DB, but now i need to Calculate Balance alone.

I have <b>"TotalAccountAmount"</b> which describe the total <b>amount of Billing</b> made for a particular customer. Now i need to calculate these above scenario based on my "TotalAccountAmount"

Please help me how to do it with CrystalReport FormulaField ???

推荐答案

嗨Karthick，



写下捕捉余额值的公式。



使用Crystal报表设计器，

1.从插入菜单中选择字段资源管理器窗口 - >字段对象

2.在字段浏览器窗口中单击公式字段树节点。

3.右键单击，弹出菜单将打开并选择新建菜单。 />
4.它将打开另一个窗口询问公式名称。输入公式名称并单击确定按钮。

5.将打开公式编辑器窗口，输入公式名称

6.在公式编辑器窗口中单击报告字段树视图并选择其他明智的借记栏和信用栏直接输入如下 {Ledger.Debit} - {Ledger.Credit} 7。点击保存并关闭按钮

8.最后将该公式拖到您的报告详细信息部分。



现在它在您的水晶报告中显示余额值

hi Karthick,

Write the formula for capturing balance value.

Using Crystal report designer,
1. select Field Explorer window from Insert Menu --> Field Object
2. Click "Formula Fields" Tree node from field explorer window.
3. Right click, popup menu will open and select "New" menu.
4. It will open another window to ask Formula name. enter formula name and click ok button.
5. It will open Formula Editor window with entered formula name
6. In that formula editor window click Report fields tree view and select Debit column and credit column other wise directly type like this {Ledger.Debit} - {Ledger.Credit}7. Click save and close button
8. Finally drag that formula to your report detail section.

Now it shows balance value in your crystal report

在这里，本文适合您（查看库存余额公式 - 截图）

在Crystal Report中使用公式 [ ^ ]

Here you go, this article is for you(Check the Stock balance formula there - screenshot)
Using Formula in Crystal Report[^]

这篇关于Crystal Report公式计算信用卡和借记卡的余额的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！