We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Filtering And Table Summary Rows Not working when sfdatagrid has preview rows

Thread ID:

Created:

Updated:

Platform:

Replies:

150853 Jan 22,2020 06:12 AM UTC Feb 7,2020 02:09 PM UTC WinForms 5
loading
Tags: SfDataGrid
mahendra
Asked On January 22, 2020 06:12 AM UTC

Hi,
I was using preview rows in sfdatagrid and when i tried filtering i throws index out of bound error.
Same Error with the summary rows for columns.
arameter name: index</Message><StackTrace>   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Syncfusion.WinForms.DataGrid.SpannedDataRow.CreateColumn(Int32 index, Int32 widthIncrementation)
   at Syncfusion.WinForms.DataGrid.SpannedDataRow.OnGenerateVisibleColumns(VisibleLinesCollection visibleColumnLines)
   at Syncfusion.WinForms.DataGrid.RowGenerator.CreateTableSummaryRow(Int32 rowIndex, VisibleLinesCollection visibleColumns, VerticalPosition position)
   at Syncfusion.WinForms.DataGrid.RowGenerator.UpdateRow(IEnumerable`1 rows, Int32 rowIndex)
   at Syncfusion.WinForms.DataGrid.RowGenerator.EnsureRows(VisibleLinesCollection visibleRows)
   at Syncfusion.WinForms.DataGrid.GridPainter.EnsureItems(Boolean ensureColumns)
   at Syncfusion.WinForms.DataGrid.GridPainter.OnPaint(PaintEventArgs e, Size clientSize)
   at Syncfusion.WinForms.DataGrid.TableControl.OnPaint(PaintEventArgs e)
   at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
   at System.Windows.Forms.Control.WmPaint(Message&amp;amp; m)
   at System.Windows.Forms.Control.WndProc(Message&amp;amp; m)
   at Syncfusion.WinForms.Controls.SfScrollControl.WndProc(Message&amp;amp; msg)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp;amp; m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;amp; m)
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Syncfusion.WinForms.DataGrid.SpannedDataRow.CreateColumn(Int32 index, Int32 widthIncrementation)
   at Syncfusion.WinForms.DataGrid.SpannedDataRow.OnGenerateVisibleColumns(VisibleLinesCollection visibleColumnLines)
   at Syncfusion.WinForms.DataGrid.RowGenerator.CreateTableSummaryRow(Int32 rowIndex, VisibleLinesCollection visibleColumns, VerticalPosition position)
   at Syncfusion.WinForms.DataGrid.RowGenerator.UpdateRow(IEnumerable`1 rows, Int32 rowIndex)
   at Syncfusion.WinForms.DataGrid.RowGenerator.EnsureRows(VisibleLinesCollection visibleRows)
   at Syncfusion.WinForms.DataGrid.GridPainter.EnsureItems(Boolean ensureColumns)
   at Syncfusion.WinForms.DataGrid.GridPainter.OnPaint(PaintEventArgs e, Size clientSize)
   at Syncfusion.WinForms.DataGrid.TableControl.OnPaint(PaintEventArgs e)
   at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
   at System.Windows.Forms.Control.WmPaint(Message&amp;amp; m)
   at System.Windows.Forms.Control.WndProc(Message&amp;amp; m)
   at Syncfusion.WinForms.Controls.SfScrollControl.WndProc(Message&amp;amp; msg)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp;amp; m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;amp; m)
   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dll
Index was out of range. Must be non-negative and less than the size of the collection.

Saravanan Ayyanar [Syncfusion]
Replied On January 23, 2020 01:28 PM UTC

Hi Mahendra, 
 
Thank you for using Syncfusion controls. 
 
Query 1: 
 
We have checked your reported scenario “Filtering not worked when SfDataGrid has preview rows” with provided your call stack on our end, but the issue is not reproduced and its work as expected on our end. Please find the below sample link. 
 
Sample Link: 
 
Note : We have tested this sample in our Syncfusion version 17.4.0.39. 
 
Please check the sample and let us know if you still facing the same issue? If not, please modify the sample based on your scenario and revert us back. It will help us to investigate further and provide earlier prompt solution. 
 
Query 2: 
 
We can replicate the reported issue “Table summary row with ShowSummaryInRow as false not worked SfDataGrid has preview rows” with provided your both call stack on our end and created the bug report for the same. Can you please specify your current Syncfusion version so that we will provide a patch for that version.  
  
Regards, 
Saravanan A. 


mahendra
Replied On January 23, 2020 02:52 PM UTC

Thanks for the sample code,
As I have tested given demo and it is working fine with filters.

Currently I am using 17.2.0.34 version.

Can I get a patch for this version. because updating to latest version is quite tough.
Filters with 17.2.0.34 is Not Working
Thank You

mahendra
Replied On January 23, 2020 04:08 PM UTC

And It seems i have found another problem .
Then Sfdatagrid has more than one table summary rows and table has preview rows .
Filters throws index out of bound.
Can You please help me out with this.

Saravanan Ayyanar [Syncfusion]
Replied On January 24, 2020 02:07 PM UTC

Hi Mahendra, 
 
Thank you for your update. 
 
Query 1: 
We have checked your reported scenario “Filtering not worked when SfDataGrid has preview rows” on our end, but the issue not reproduced and its works as expected on our end. Please find the below sample link. 
 
Sample Link: 
 
NOTE: We have checked Syncfusion version as 17.2.0.34. 
 
Please check the sample and let us know if you still facing the same issue? If not, please modify the sample based on your scenario and revert us back. It will help us to investigate further and provide earlier prompt solution. 
 
Query 2: 
 
We can replicate the reported issue “More than one Table Summary row with ShowSummaryInRow as true not worked SfDataGrid has preview rows” on our end and created bug report for the same. 
 
We will fix both reported issue “More than one Table Summary row with ShowSummaryInRow as true not worked SfDataGrid has preview rows” and “Table summary row with ShowSummaryInRow as false not worked SfDataGrid has preview rows” and provide the patch for this issue in your version 17.2.0.34 on February 7th, 2020. 
 
You can track the status of this report through the following feedback link, 
 
Feedback Link:  
     
We appreciate your patience until then. 
Regards, 
Saravanan A.   

Saravanan Ayyanar [Syncfusion]
Replied On February 7, 2020 02:09 PM UTC

Hi Mahendra, 
 
Query 2: 
 
Thanks for your patience. 
 
The issue with "ArgumentOutOfRangeException is thrown when preview row and table summary are added" has been fixed and the patch for this fix can be downloaded from the following location.  
 
Recommended approach - exe will perform automatic configuration 
Please find the patch setup from below location: 
 
Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment 
Please find the patch assemblies alone from below location: 
 
Assembly Version: 17.2.0.34 
Installation Directions :  
This patch should replace the files “Syncfusion.SfDataGrid.Winforms” under the following folder. 
$system drive:\ Files\Syncfusion\Essential Studio\$Version # \precompiledassemblies\$Version#\4.6 
Eg : $system drive:\Program Files\Syncfusion\Essential Studio\17.2.0.34\precompiledassemblies\17.2.0.34\4.6 
 
To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies. 
 
Note :  
You can change how you receive bug fixes by navigating to the following link and updating your preferences. 
 
 
Disclaimer :  
Please note that we have created this patch for version 17.2.0.34 specifically to resolve the following issue reported in this Forum 150853. 
 
If you have received other patches for the same version for other products, please apply all patches in the order received. 
 
Regards, 
Saravanan A. 
 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon