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.

error when trying to add PivotComputationInfo to PivotCalculations

Thread ID:





121917 Feb 8,2016 01:16 PM Feb 11,2016 07:28 AM Windows Forms 5
Tags: PivotGridControl
Asked On February 8, 2016 01:16 PM

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 12:19 PM

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 9, 2016 11:40 PM

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 07:27 AM

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 11:03 AM

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 07:28 AM

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.

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.