Hi everyone,
I' m creating a "Sale Forwarding Report" using crystal report. I want to carry forward closing balance.This is closing balance formula in my report ;
closingBalance=(openingBal
ance+saleA
mt)-(incom
ingPayment
+discountA
mt+advance
Opening+de
bt_Balance
).
This report is printed look like:
No. Content. Cashfund-1......Cashfund-6
1. openingBalance 50000. ......12000
2. saleAmt. 8500. .......40000
3. 1+2. 58500. .....52000
4. incomingPayment 3000 ... 20000
5. discountAmt. 1500. ....5000
6. advanceOpening. 7500. .....10000
7. debt-Balance. -1500. ......-7500
8. 4+5+6+7. 10500 .......27500
9. closingBalance(3-8). 48000.......24500
This is example data for january and I want to use january's closing balance as opening balance for february. In this report, I created two parameters - {?FromDate} and {?ToDate} .I want to pass these two parameters for only one month (for each month). How can I do this?
The following attachment file is testing for my report.
Kind Regards,
ZMT
There is no way to do that in Crystal except by exporting the report data Excel and use that as an input to the next month's report.
mlmcc