problem in crystal report
-
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.
-
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.
This is not a report problem, it is a SQL issue. You must create the query that produces the results for the report to display. So one of the columns in your result set needs to be opening balance
Never underestimate the power of human stupidity RAH
-
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.
One of the things that I have done is create a XSD for the report and pass the data to the report from your code so that you can do whatever manipulation you want prior to handing it to crystal. report.DataSource = (object with same schema as the XSD)
Thanks JD http://www.seitmc.com/seitmcWP