Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Get Balance With Credit And Debit Fields Post Reply Post New Topic
Author Message
swallow.pa
Newbie
Newbie


Joined: 26 Apr 2012
Online Status: Offline
Posts: 26
Quote swallow.pa Replybullet Topic: Get Balance With Credit And Debit Fields
     Posted: 26 Apr 2012 at 8:22am
hi
I Have Two Fields in My Report.
Credit And Debit

Record            Debit            Credit        Result Or Balance
1                     250                  0               250
2                      50                    0               300
3                         0                   80             220
4                       10                     0             230
5                        0                     75            305
----------------------
 How to do Get Balance or Result in Crystal ReportOuch
please help me Clap
thanks

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 26 Apr 2012 at 9:07am
create a formula field as
table.debit - table.credit and use that formula field in a running total or shared variable formula
IP IP Logged
swallow.pa
Newbie
Newbie


Joined: 26 Apr 2012
Online Status: Offline
Posts: 26
Quote swallow.pa Replybullet Posted: 26 Apr 2012 at 6:52pm
please create a sample code
IP IP Logged
swallow.pa
Newbie
Newbie


Joined: 26 Apr 2012
Online Status: Offline
Posts: 26
Quote swallow.pa Replybullet Posted: 26 Apr 2012 at 7:20pm
thanks solved the problem
now how to do invisible Text in my ReportHug
IP IP Logged
swallow.pa
Newbie
Newbie


Joined: 26 Apr 2012
Online Status: Offline
Posts: 26
Quote swallow.pa Replybullet Posted: 26 Apr 2012 at 7:25pm
my god i check suppress in my report
SOLVED THE PROBLEM
THANKS ALLBig%20smile
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum