Hi
I have two tables issue and receive how to show balance (issue qty )- (receive qty) balance in radgridview
issue Table
| IssueId | MaterialId | ItemId | LotNo | IssueWt | IssueQty |
| 1 | 1 | 9 | 22050001 | 100 | 1 |
| 2 | 1 | 11 | 22050002 | 75 | 1 |
| 3 | 1 | 13 | 22050003 | 15 | 1 |
| 4 | 1 | 5 | 22050003 | 1 | 1 |
| 5 | 1 | 17 | 22050003 | 1 | 1 |
Receive Table
| ReceiveId | MaterialId | ItemId | LotNo | ReceiveWt | ReceiveQty |
| 1 | 1 | 7 | 22050001 | 75 | 1 |
| 2 | 1 | 16 | 22050002 | 25 | 1 |
| 3 | 1 | 2 | 22050003 | 10 | 1 |
| 4 | 1 | 17 | 22050003 | 1 | 1 |
| 5 | 1 | 17 | 22050003 | 1 | 1 |
| 6 | 1 | 17 | 22050003 | 1 | 1 |
Output
| Lot No | IssueWt | ReceiveWt | Balance |
| 22050001 | 100 | 75 | 25 |
| 22050002 | 75 | 25 | 50 |
| 22050003 | 17 | 13 | 4 |
1 Answer, 1 is accepted
Hello, Nandan,
According to the provided information, it is not clear which table exactly is used for populating RadGridView. However, I believe that it is the Output table. The two columns, IssueWt and ReceiveWt, can be directly added either programmatically. As to the Balance column, it can be automatically calculated having the two mentioned columns that are present in RadGridView. It is just necessary to specify the Expression for the Balance calculated column. Additional information is available in the following help article:
I hope this information helps. If you need any further assistance please don't hesitate to contact me.
Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.
Rank 1
Iron
Iron
Iron
Thanks i resolve it by using SQL statement
Thanks again Dess