sfDataGrid caption summary
Hi Manikanda,
Picture 1.
Ther is no Title. I put same code as in your example from internet sight (this code is similar to yours in example that you sent me), but still there is no title.
Obviously, I am doing something wrong, but I don't know what.
Without Caption Summery Row I got this
Picture 2.
I want to keep Group titles ("Sintetika 200 - Kupci - matična i zavisna pravna lica" from Picture 2) and Sums for Columns "Duguje", "Potrazuje" and "Saldo".
Another thing that confuses me is that the summery (in Picture 1) is without decimal places even that the values in the table are with decimal places. In the example from the internet sight Sums of currency values are shown with decimal places.
I also tried to use Creating Custom Renderer to change format of column sums (to add decimal places and to remove RSD - currency name) but when I added
Public Class CustomGridCaptionSummaryRenderer
Inherits GridCaptionSummaryCellRenderer
Protected Overrides Sub OnRender...and
Me.sfDataGrid1.CellRenderers.Remove("CaptionSummary")
Me.sfDataGrid1.CellRenderers.Add("CaptionSummary", New CustomGridCaptionSummaryRenderer())a lot of errors come up.
Error BC30284 sub 'OnRender' cannot be declared 'Overrides' because it does not override a sub in a base class. EM_2024_1 D:\VB Net\VB Net Projects\Aktuelno\EM-2024_1\EM-2024_1\KF_KontniPlan.vb 453 Active
Error BC30002 Type 'RowColumnIndex' is not defined. EM_2024_1 D:\VB Net\VB Net Projects\Aktuelno\EM-2024_1\EM-2024_1\KF_KontniPlan.vb 453 Active
Error BC30518 Overload resolution failed because no accessible 'DrawString' can be called with these arguments:
'Public Overloads Sub DrawString(s As String, font As Font, brush As Brush, x As Single, y As Single)': Value of type 'Rectangle' cannot be converted to 'Single'.
'Public Overloads Sub DrawString(s As String, font As Font, brush As Brush, x As Single, y As Single)': Value of type 'StringFormat' cannot be converted to 'Single'.
'Public Overloads Sub DrawString(s As String, font As Font, brush As Brush, point As PointF, format As StringFormat)': Value of type 'Rectangle' cannot be converted to 'PointF'.
'Public Overloads Sub DrawString(s As String, font As Font, brush As Brush, layoutRectangle As RectangleF, format As StringFormat)': Value of type 'Rectangle' cannot be converted to 'RectangleF'. EM_2024_1 D:\VB Net\VB Net Projects\Aktuelno\EM-2024_1\EM-2024_1\KF_KontniPlan.vb 469 Active
I attached my form called "KF_KontniPlan" if that can help to solve this.
I am writing code in vb.net (.NET Framework 4.8.1) so please if you sand me example can it be written in vb.net .Net Framework 4.8.1.
Once again thank you very much for previous answer.
Sincerely,
Sabian
Attachment: KF_KontniPlan_e6735b45.zip
Hi Sabian Sirius,
We have tried to attach the MDF file you have shared in the SSMS. but it throws and error that the "MDF file is not a primary file". We have tried to resolve this issue by taking the full control to the MDF file. but the issue was not resolved. If possible, could you please provide the backup file for the databases you have shared to resolve these types of errors? It will help us to launch the sample and validate the reported issue.
Error:
Regards,
Sreemon Premkumar M.
Hi Sreemon Premkumar M.
While I was waiting for your answer, I analyzed my database. Because I couldn't get Master Detail View I thought that maybe something is wrong with my database (Views, Tables). So I started to recreate database. As soon as I finish it, I will sand you Backup.
Regarding Grouping View in SfDataGrid, I also noticed in your example for Winforms controls (Syncfusion Essential Studio Control Panel 25.1.35) that Custom Summary Row on my computer is showing same thing as in my project.
Sums of columns in Group row are left aligned, has currency symbol (RSD) after value and there are no decimal places even that the value in column has decimal numbers.
Here are settings on my computer
As I have written I didn't succeed to change this in my code.
Once again thank you for your support and quick answers. I am sending you database soon.
Best Regards
Sabian
Hi Sabian Sirius,
Thanks for the update.
The reason the currency symbol in the caption summary appears after the value and without decimal places is due to the culture (Serbian) set in your computer's system settings. We were able to replicate the same behavior on our end when setting the culture to Serbian using the code snippet below. This is the default behavior when setting the Serbian culture, and we haven't done anything specific for this culture. Please refer to the image below.
Code snippet:
System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("sr-RS") System.Threading.Thread.CurrentThread.CurrentUICulture = New System.Globalization.CultureInfo("sr-RS") |
Serbian culture image:
In the image below, you can see that when the culture is set to English (United States), the currency symbol is positioned before the value and includes decimal places.
Regarding the alignment of the caption summary row, you can set the alignment of the caption summary row by setting SfDataGrid.Style.CaptionSummaryRowStyle.HorizontalAlignment to Right. Before setting the alignment of the caption summary row, ensure that SfDataGrid.Style.CaptionSummaryRowStyle.TextMargin is set to 0. By default, it has a value of (12,0,12,0). Please find the code snippet below.
Code snippet:
this.sfDataGrid.Style.CaptionSummaryRowStyle.TextMargins = new Padding(0, 0, 0, 0); this.sfDataGrid.Style.CaptionSummaryRowStyle.HorizontalAlignment = HorizontalAlignment.Right; |
Output:
Regards,
Sreemon Premkumar M.
Hi Sabian Sirius,
Query 1: Can Title be left alignment and sums (columns “Duguje”, “Potrazuje” and “Saldo”) stayed right alignment?
Your requirement to align the caption summary title to the left and other caption summary column values to the right can be achieved by setting the CaptionSummaryRowStyle.HorizontalAlignment to right and setting the Style.HorizontalAlignment to left by checking whether the column has the title, by overriding the GridCaptionSummaryCellRenderer. Please find the code snippet below.
Code snippet:
Me.SfDataGrid1.Style.CaptionSummaryRowStyle.TextMargins = New Padding(0, 0, 0, 0) Me.SfDataGrid1.Style.CaptionSummaryRowStyle.HorizontalAlignment = HorizontalAlignment.Right //Overriding the GridCaptionSummaryCellRenderer to change the alignment. Public Class CustomGridCaptionSummaryRenderer Inherits GridCaptionSummaryCellRenderer Protected Overrides Sub OnRender(paint As Graphics, cellRect As Rectangle, cellValue As String, style As CellStyleInfo, column As DataColumnBase, rowColumnIndex As RowColumnIndex) 'OrderID is the first column. 'This sets the title of the caption summary to Left. If column.GridColumn.MappingName = "OrderID" Then style.HorizontalAlignment = HorizontalAlignment.Left End If MyBase.OnRender(paint, cellRect, cellValue, style, column, rowColumnIndex) End Sub End Class |
We understand that you are facing some errors when overriding the GridCaptionSummaryCellRenderer, but it is the correct way to set the title to the left and the other caption summary columns to the right.
Please let us know if you are still facing the same errors when overriding the GridCaptionSummaryCellRenderer.
Query 2: Can these titles be displayed without those four columns (“Godina”, “Klasa”, “Grupa” and “Sintetika”) set to visible? I think you somehow did it in your example.
We were able to replicate the issue by hiding the columns in a simple sample. In the previously shared sample, we set the visibility to false for the last three columns, so that it does not affect the showing of the caption summary title. We are currently investigating this behavior at the source level. We need some time to validate it and will update you with further details on or before May 30, 2024. We appreciate your patience until then.
Query 3: how can I read data from Title of the CaptionSummaryRow when I click on it?
Your requirement to read or get the value of the caption summary when clicking on the caption summary can be achieved by using the SummaryCreator.GetSummaryDisplayTextForRow() method inside the SfDataGrid.CellClick event. Please find the code snippet below.
Code snippet:
Private Sub sfDataGrid1_CellClick(sender As Object, e As CellClickEventArgs) Dim summaryRowInfo As Group = TryCast(e.DataRow.RowData, Group) If summaryRowInfo IsNot Nothing Then If summaryRowInfo.SummaryDetails IsNot Nothing Then Dim value = SummaryCreator.GetSummaryDisplayTextForRow(summaryRowInfo.SummaryDetails, Me.SfDataGrid1.View) MessageBox.Show(value, "Caption Value") End If End If End Sub |
Output:
Regards,
Sreemon Premkumar M.
Attachment: SfDataGrid_CaptionSummary_VB_5841b4a9.zip
Hi Sreemon Premkumar M.,
As you suggested I made some changes in code.
First, I added these imports
Imports System.Collections.ObjectModel
Imports Syncfusion.WinForms.GridCommon.ScrollAxis
Imports System.ComponentModel
Imports Syncfusion.Windows.Forms
Imports Syncfusion.WinForms.DataGrid.Interactivity
that were not in my form (KF_KontniPlan.vb)
There was still marked error on
Protected Overrides Sub OnRender(paint As Graphics, cellRect As Rectangle, cellValue As String, style As CellStyleInfo, column As DataColumnBase, rowColumnIndex As RowColumnIndex)
OnRender was marked and RowColumnIndex was marked.
Then Visual Studio suggested to change code in this
Protected Overrides Sub OnRender(paint As Graphics, cellRect As Rectangle, cellValue As String, style As CellStyleInfo, column As DataColumnBase, rowColumnIndex As Syncfusion.WinForms.GridCommon.ScrollAxis.RowColumnIndex)
it added this in line
Syncfusion.WinForms.GridCommon.ScrollAxis
so, I got Syncfusion.WinForms.GridCommon.ScrollAxis.RowColumnIndex and there were no marked error.
I started program and this popup on screen
This is within
C:\Users\Peko\AppData\Local\Temp\.vsdbgsrc\c724e65a8f7b77b140b8aed99aab2dd855c16aea23ce6a697770896aaa480b05\GridSummaryCellRendererBase.cs
This is part of code
public class GridSummaryCellRendererBase : GridCellRendererBase
{
protected override void OnRender(Graphics paint, Rectangle cellRect, string cellValue, CellStyleInfo style, DataColumnBase column, RowColumnIndex rowColumnIndex)
{
/* This line was marked yellow* - I underline it/
int num = base.TableControl.DataGrid.GroupColumnDescriptions.Count + Convert.ToInt32(base.TableControl.DataGrid.ShowRowHeader) + ((base.TableControl.DataGrid.DetailsViewDefinitions != null) ? base.TableControl.DataGrid.DetailsViewDefinitions.Count : 0) + Convert.ToInt16(base.TableControl.DataGrid.ShowPreviewRow);
DrawingHelper.PaintCellBackground(paint, cellRect, style, canApplyInterior: true);
if (string.IsNullOrEmpty(cellValue))
{
return;
}
I will also try to analyze database. If there is a problem.
Best regards
Sabian
Hi Sreemon Premkumar M.,
Here is an update for CaptionSummaryRow.
I reinstalled Visual Studio and Syncfusion components, but nothing changed at first.
I added some new code for connecting MS SQL Server to application (checking and adding records to database). I started application few times to check does it work OK. Adding data and checking records was OK. After a while I noticed this warning in Visual Studio
Severity Code Description Project File Line Suppression State
Warning The explicit binding redirect on "Syncfusion.Calculate.Base, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" conflicts with an autogenerated binding redirect. Consider removing it from the application configuration file or disabling autogenerated binding redirects. The build will replace it with: "<bindingRedirect oldVersion="0.0.0.0-26.1462.41.0" newVersion="26.1462.41.0" xmlns="urn:schemas-microsoft-com:asm.v1" />". EM_2024_1
Warning The explicit binding redirect on "Syncfusion.Licensing, Culture=neutral, PublicKeyToken=632609b4d040f6b4" conflicts with an autogenerated binding redirect. Consider removing it from the application configuration file or disabling autogenerated binding redirects. The build will replace it with: "<bindingRedirect oldVersion="0.0.0.0-26.1462.41.0" newVersion="26.1462.41.0" xmlns="urn:schemas-microsoft-com:asm.v1" />". EM_2024_1
I started application once more. Application started with no problem or error. I opened form with SfDataGrid it worked as previous did (I didn't call Overrides subroutine). Then I tried to call subroutine to Override alignment.
I was shocked, everything worked just fine as I wanted at the beginning.
Caption titles to be left alignment and sums to be right alignment.
I don't know what has happened, but it works.
I want to thank you once again for your effort and spent time to help me solve this problem.
Best regards,
Sabian
