Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imranabdulaziz
Yak Posting Veteran
83 Posts |
 Posted - 2009-04-23 : 05:59:26
|
| Dear All,I am using sql 2005 and ssrs 2005.I am preparing stock ledger report where I need to show opening and closing balance of stock along with it issue and receive My report will look like Item itemcode Issue Receive Balance Qty DatePen Opening :30 Abc 1 0 29 13-04-09 DEF 0 1 30 14-04-09 GHI 2 0 28 15-04-09 CLOSING : 28 I am able to fetch issue , receive , opening balance , item , itemcode , date but balance qty need to be calculated . Please help. |
|
|
|
|
|
Calculating balance qty based on previous row bala