How to show issue and Receive balance in gridview

1 Answer 13 Views
GridView
Nandan
Top achievements
Rank 1
Iron
Iron
Iron
Nandan asked on 17 May 2022, 10:05 AM

Hi

I have two tables issue and receive how to show balance (issue qty )- (receive qty) balance in radgridview

issue Table

IssueIdMaterialIdItemIdLotNoIssueWtIssueQty
119220500011001
211122050002751
311322050003151
4152205000311
51172205000311

Receive Table 

ReceiveIdMaterialIdItemIdLotNoReceiveWtReceiveQty
11722050001751
211622050002251
31222050003101
41172205000311
51172205000311
61172205000311

Output

Lot NoIssueWtReceiveWtBalance
220500011007525
22050002752550
2205000317134

 

1 Answer, 1 is accepted

Sort by
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 17 May 2022, 10:34 AM

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:

https://docs.telerik.com/devtools/winforms/controls/gridview/columns/calculated-columns-(column-expressions

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.

Nandan
Top achievements
Rank 1
Iron
Iron
Iron
commented on 18 May 2022, 01:25 PM

Thanks i resolve it by using SQL statement

Thanks again Dess

 

Tags
GridView
Asked by
Nandan
Top achievements
Rank 1
Iron
Iron
Iron
Answers by
Dess | Tech Support Engineer, Principal
Telerik team
Share this question
or