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.
Unfortunately, activation email could not send to your email. Please try again.

Problem hiding Grand Totals. Grand totals remain visible and one data column and one data row get hidden

Thread ID:

Created:

Updated:

Platform:

Replies:

125216 Jul 31,2016 05:13 PM Aug 1,2016 08:47 AM Windows Forms 1
loading
Tags: PivotGridControl
Carlos Fernando Consigli
Asked On July 31, 2016 05:13 PM

Hello. I'm having problems hiding the grand totals in pivot grid controls for Windows Forms.
I have some anual values and I need to show like
2003 2004 2005 2006
0.5 0.5 0.5 0.5    and so on.

I know it seems a little simple problem for a PivotGridControl, but this is just one of the scenarios I'm dealing with and I tried to simplify the sample to isolate the error.

I'm attaching this simple application for you to reproduce it (it's a Visual Studio 2010 Windows forms project).

I may be setting up the pivot control wrongly, but I'm not sure. You'll see that not only the Grand row and columns are being shown when they shouldn't, but also that the row of data has disappeared and also the column for the first year (2003) is missing.
In the Visual Studio immediate window, there can be seen these two errors:

   System.ArgumentException: negative key
   en Syncfusion.Windows.Forms.Grid.GridIndexDictionary.OnValidate(Object key, Object value)
   en Syncfusion.Collections.TypedDictionaryBase.System.Collections.IDictionary.set_Item(Object key, Object value)
   en Syncfusion.Windows.Forms.Grid.GridIndexDictionary.set_Item(Int32 key, Object value)
   en Syncfusion.Windows.Forms.Grid.GridRowColHideDictionary.set_Item(Int32 index, Boolean value)
   en Syncfusion.Windows.Forms.Grid.GridModelHideRowColsIndexer.SetHidden(Int32 index, Boolean value)
   en Syncfusion.Windows.Forms.Grid.GridModelHideRowColsIndexer.SetRange(Int32 from, Int32 last, Boolean[] values, Boolean discardUndo)
    System.ArgumentException: negative key
   en Syncfusion.Windows.Forms.Grid.GridIndexDictionary.OnValidate(Object key, Object value)
   en Syncfusion.Collections.TypedDictionaryBase.System.Collections.IDictionary.set_Item(Object key, Object value)
   en Syncfusion.Windows.Forms.Grid.GridIndexDictionary.set_Item(Int32 key, Object value)
   en Syncfusion.Windows.Forms.Grid.GridRowColHideDictionary.set_Item(Int32 index, Boolean value)
   en Syncfusion.Windows.Forms.Grid.GridModelHideRowColsIndexer.SetHidden(Int32 index, Boolean value)
   en Syncfusion.Windows.Forms.Grid.GridModelHideRowColsIndexer.SetRange(Int32 from, Int32 last, Boolean[] values, Boolean discardUndo)

that I think may be related with this. I've tried the code in C# instead of VB.net and I get the exact same behaviour.

I'm using Syncfusion version 14.2400.0.26.
Thanks in advance for your help.

Fernando Consigli


Attachment: PivotGridGrandTotalsProblem_6c95dcaf.zip

Anish George [Syncfusion]
Replied On August 1, 2016 08:47 AM

Hi Carlos,  
 
Thank you for using Syncfusion products. 
 
We are able to reproduce the issue in the given sample. We request you to create a DT incident regarding this, so that our dedicated engineers will work on it and will give you proper details on this issue. You can create the DT incident from the following link.  
  
  
Please let me know if you have any concerns.  
  
Regards,  
Anish. 


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.

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.

;