I am using xamPivotGrid and FlatDataSource as its source.
When I add rows and cols to FlatDataSource (as below), I get the following exception
flatDataSource.Columns = DataSourceBase.GenerateInitialItems("[Index Name].[Index Name]");
flatDataSource.Rows = DataSourceBase.GenerateInitialItems("[End Date].[End Date],[Gpt Name].[Gpt Name]");
An item with the same key has already been added. ...
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at Infragistics.Olap.DataSourceBase.CreateResultCache IResult
Is there any workaround for this.
I get this error/excetion only when I do a
pivotGrid.DataSource.Refresh after I set its DataSouce = FlatDataSource (will rows and cols initialized).
This is definitely a bug. When I refresh, it seems to be using the olf cache to refresh. the grid.
I remove the refresh and it works fine. Refresh is apparently not needed in this case.
I have been looking into the issue that you are having and I could not manage to reproduce it. Would you please, if possible, send me a sample application in which the issue appears in order to be able to investigate it more detialiled?
Looking forward to hearing from you.
Developer Support Engineer
I am checking if this is still an issue for you.
If you require any further assistance please do not hesitate to ask.
I have a similar issue...