opening and closing balance in c#

Question

1.00/5 (1 vote)

See more:

how do i get opening balance from previous day closing balance.

here is the example

date 14/2/2013 closingbalance 2000

date 15/2/2013 opening balance 2000

credit 2000
debit 500
date 15/2/2013 closingbalance 3500

date 16/2/2013 opening balance 3500 and so on

here previous closing balance become opening balance.

problem is that i have to show data between date and no idea how to get opening balance of first record.

i am using sqlser 2005 and crystal report 10.

Posted 1-Feb-14 9:31am

Shuaib wasif khan

Add a Solution

Comments

Sergey Alexandrovich Kryukov 1-Feb-14 18:59pm

The question does not make much sense. It all depends on how you design your code and data structures.
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Baxter P · Answer 1 · 2014-02-01T15:51:00

Solution 1

I think you need to consider the closing day time AND date, eg 01-01-2014 23:59:59

Then the same with the opening day balance as, say 01-02-2014 00:00:00

Then they should be the same.

Posted 1-Feb-14 15:51pm

Baxter P