i have a gridgroupingcontrol that contains a payment type column (ptype). Each payment type comes with an amount which is in column (amt). i have being trying to create a summary for for the total payment amount for each payment type. I was able to do this with the default Microsoft data grid. am having difficulty doing the same with the syncfusion grid. kindly help.

pls reply

Hi Harry,

Thanks for using Syncfusion Products.

Your requirement can be achieved by using the Summary Rows in GridGroupingControl. We have prepared simple sample to meet your requirements and the same can downloaded from the below link.

Summary80855377.zip

Please try the above sample and if it does not meets your requirement, could you please provide more information on this so that we can provide a better solution quickly?.

Note: For more information on the summary rows, we request you to refer the below link.

http://help.syncfusion.com/ug_94/User%20Interface/ASP.NET/Grid/Documents/4112captionsummary.htm

Please let us know if you have any concerns.

Regards,
Bala Murugan A.S

hello guys

In our business there are two payment types
1. Reversal Payment (R)
2. Actual Payment (P)

both payment types can be select by the user in the ptype column filter. both payment type comes with an amount which is in the Amount column.

total payment = P - R

the requirement is to display the total sum of each payment type
and the total payment in separate summarycolumn

R:2000
P:5000
total payment:3000

Hi Harry,

Thanks for the update.

Your requirement can be achieved by using Custom Summary and CreateSummaryMethod method in GridGroupingControl. We have modified the sample as per your requirement and the same can be downloaded from the below link.

Summary_Modified1273161658.zip

Please try the above sample and let us know if you need further assistance.

Regards,
Bala murugan A.S

hi we really appreciate the help. but will be happy i happy if example will be in vb.net.
thank you

Harry

Hi Harry,

Thanks for the update.

We have modified sample which was provided in the last update to VB.Net and the same can be downloaded from the below link.

Summary_VB.Net-1121312620.zip

Please let me know if you need further assistance.

Regards,
Bala Murugan A.S

thank you guys.

Hello guys,

thanks a lot for the help. I have a small challenge. I tried to add another ptype "default Return (T)" but summary is not behaving like the previous one. the value of its summary is always the sum R and R summary row values

example

P:20
R:2
T:22
ACTUAL PAYMENT:18

pls help

The example in the Attached file shows how my summary is behaving.

Thanks alot


Harry



Summary_VB.Net_harry_d3bc91d0.rar

please reply. Am in a tight corner.

Harry.

Hi Harry,

Thanks for the update.

Sorry for the delay in getting back to you. We have modified the sample as per your requirement and the same can be downloaded from the below link,
Summary_VB.Net25957222.zip

Please try the above sample and let us know if you have any concerns

Regards,
Bala Murugan A.S

Can i know how you were able to display the default amount correctly. I can't seem to know what i am doing wrong.

please help

Hi Harry,

Thanks for the update.

Using CreateSummaryMethod in GridGroupingControl you can customize the summary row. Navigate each record in a grid and calculate the summary values based on your condition. For example the below code calculate summary value only if Payment type is Actual Payment.


If record IsNot Nothing AndAlso record.Kind = DisplayElementKind.Record AndAlso CStr(record.GetValue("PType")) = "Actual Payment" Then
Dim obj As Object = sd.GetValue(record
Return If((obj Is Nothing OrElse TypeOf obj Is DBNull), Empty, New TotalSummary(Convert.ToDouble(obj)))
Else
Return Empty
End If


Please let me know if you need further assistance.

Regards,
Bala Murugan A.S