Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: CrystalReports
Current Day: Opening Balance 1000 Dr
 
Debit Credit
 
500 100
 
Closing Balance 1400
My Calculation 500 100 --> i got a output this one- output was not correct
 
Daily Total(Sum) 1500 1500 --> this output was correct
 

Next Day Opening Balance 1400 Dr
 
I need daily total amount tally to particular transaction.
Posted 23-May-13 1:53am
Comments
Kschuler at 23-May-13 12:11pm
   
Please explain more. What I'm reading is that you start with 1000. Then you Debit 500 and Credit 100. Which to me means 1000-500+100=600. So how could 1400 be the closing balance? What calculations are you actually using? And what are you actually asking for? A crystal reports formula? Or what? Click the Improve question link and give us more information so we can help you.
NathiShariq at 25-May-13 1:35am
   
simply started with 1000 rs debit. first check the opening balance debit or credit. if debit means use a formula opening balance+debit-credit. otherwise opening balance-debit+credit.check the crystal report formula link
http://sql2000forgp.wordpress.com/2009/09/23/crystal-report-formula/
Kschuler at 29-May-13 8:42am
   
That didn't clarify anything for me. I understand the formula...I just don't understand your data and what you are expecting to happen. If you want help, you're going to have to clarify and step us through what you are doing using complete sentences so we know what you are talking about.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 George Jonsson 215
1 Kornfeld Eliyahu Peter 169
2 Zoltán Zörgő 139
3 PIEBALDconsult 130
4 OriginalGriff 120
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,107
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,342


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 23 May 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100