error when trying to add PivotComputationInfo to PivotCalculations

[Patrick]

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 U]

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.

Regards,
Amal Raj U

[Amal Raj U]

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.

Regards,
Amal Raj U

[Amal Raj U]

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?

Regards,
Amal Raj U

[Patrick]

Hi,

 

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.

 

Regards.

 

Patrick

[Amal Raj U]

Hi Patrick,

Thank you for the update.

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

Regards,
Amal Raj U.