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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

error when trying to add PivotComputationInfo to PivotCalculations

Thread ID:





121917 Feb 8,2016 06:16 PM UTC Feb 11,2016 12:28 PM UTC WinForms 5
Tags: PivotGridControl
Asked On February 8, 2016 06:16 PM UTC

I would like to attach a Data table to a pivot grid (in Visual Basic)
At this moment it's working fine with PivotRows and PivotColumns but not with PivotCalculations.
I have the following piece of code:

Dim newPivotComputationInfo As New PivotComputationInfo With {.BaseField = "Item", .FieldName = "Item", .SummaryType = SummaryType.Count, .CalculationName = "Count", .Format = "# ##0"}

PivotGridControl1.PivotCalculations.Add(newPivotComputationInfo )

when I try to add the PivotComputationInfoI have an exception with the following message: unreferenced opbject or something like that.

Please, any advice.

Amal Raj Umapathy Selvam [Syncfusion]
Replied On February 9, 2016 05:19 PM UTC

Hi Patrick,

Thank you for using Syncfusion products.

Exception you have mentioned is not reproduced at our side.

Do you add repeatedly in pivotcalculations or Please provide us as sample with exception occurring for reference.

Amal Raj U

Amal Raj Umapathy Selvam [Syncfusion]
Replied On February 10, 2016 04:40 AM UTC

Hi Patrick,

We regret for the inconvenience.

We have implemented an sample based on your scenario, we couldn’t reproduce the exception.

Please refer the sample VB-356959335 . If you have any further requirements, Please provide us your sample.

Amal Raj U

Amal Raj Umapathy Selvam [Syncfusion]
Replied On February 10, 2016 12:27 PM UTC

Hi Patrick,

Please ignore our previous updates.

I am afraid that I am unable to reproduce the exception with adding the PivotCalculationInfo into pivot calculations collection (as mentioned, the underlying item source is DataTable). Also I have created a simple sample to test this issue and it is available in the following link.

Sample:  http://www.syncfusion.com/downloads/support/forum/121917/ze/PivotDTVB-397536016

We have tried this in the latest version. Could you please share us the version you are using?

If still the issue exists, could you please try reproducing it in the above sample or send us the reproducing steps with your sample so that we could sort out the cause of the issue and provide you a solution?

Amal Raj U

Replied On February 10, 2016 04:03 PM UTC

Thank you very much for your advices and your code.
I'm using Visual Studio 2010 and your exemple works perfectly on my computer withsyncfusion release 13.4400 but my code is'nt. .
May it's due to the variables name. I will check tomorrow and take you in touch with my investigations.

Amal Raj Umapathy Selvam [Syncfusion]
Replied On February 11, 2016 12:28 PM UTC

Hi Patrick,

Thank you for the update.

Please let us know, If you need any further assistance.

Amal Raj U.


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