Dear All,
I have one report in that i have 4 columns
[OPENING STK] ,
[TOTAL RECEIPT] ,
[TOTAL ISSUE] ,
[CL STK AFTER EXP ]
[CL STK AFTER EXP ] = [OPENING STK] + [TOTAL RECEIPT] - [TOTAL ISSUE]
In our Database the [OPENING STK] manually entered 0 for the period of [APR 2012-13].
APR....
| PRODUCT CD | OPENING STK | TOTAL RECEIPT | TOTAL ISSUE | CL STK AFTER EXP |
| TOTAL | 0 | 4,715 | 1927 | 2788 |
| 1AS1 | 0 | 4,715 | 1927 | 2788 |
When I select May
| PRODUCT CD | OPENING STK | TOTAL RECEIPT | TOTAL ISSUE | CL STK AFTER EXP |
| TOTAL | 0 | 7,400 | 7650 | -250 |
| 1AS1 | 0 | 7,400 | 7650 | -250 |
Now my requirement is whenever user select May 2012-13 to till date [OPENING STK] will be the last month of
[CL STK AFTER EXP ]
Expected Output for May and so on month years
| PRODUCT CD | OPENING STK | TOTAL RECEIPT | TOTAL ISSUE | CL STK AFTER EXP |
| TOTAL | 2788 | 7,400 | 7650 | 2,538 |
| 1AS1 | 2788 | 7,400 | 7650 | 2,538 |
I really appreciate your help.
Please find the sample attachment for Apr data and expected out put for May
Thanks..
