How to refresh data in Pivot Table when data source changes?

[Igor Surla]

Data Source of my pivot view is bound to List or ObservableCollection in my data access layer class.

When i update that list by NodeSelected event of SfTreeView NodeSelected pivot wont refresh first time or everi next time if list is empty, 

it keeps data from previous selection.

Is there a way to resolve this?

[Sivamathi Natarajan]

Hi Igor Surla, 

 

Thanks for contacting Syncfusion support. 

 

Could you please share us your sample to replicate the same at our end? So, that we can analyze your codes at our end and provide you the solution at earliest.  

  

Regards,  

Sivamathi.  

[Igor Surla]

Hi Sivamathi Natarajan,

In attachment you could find my razor file and other necessary classes.

By default pivot should load all data.

When user pick one off the members from tree view pivot data should reload but it does not for the first time if number of rows should be less than before, also if users select option which does not have data pivot still keeps previous data.

Let me know if you need anything else.

Thanks,

Igor Surla

Attachment: PivotAndTreeSample_61a0142e.zip

[Sivamathi Natarajan]

Hi Igor Surla,  

 

Thanks for the sample to reproduce the issue at our end. We have modified the provided sample to make it work. Please check the below sample. 

 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Pivot_Table-1684632348 

 

Please let us know if you have concern. 

 

Regards, 

Sivamathi. 

[Igor Surla]

Hi Sivamathi Natarajan,

I have removed unnecessary  code from example and reattached it.

StateHasChanged(); helped with refreshing data when there is data to show.

I still have issue when there is no data to be shown.

In order to reproduce it Select Account3 from TreView.

As you can see pivot would not refresh, it will show data from previous selection.

Can you help me with this issue also?

Thanks,

Igor Surla

Attachment: Pivot_Table_e45a7c45.zip

[Sivamathi Natarajan]

Hi Igor Surla,  

 

If the data source is empty, you will get the empty grid view. So, kindly bind the data source before you do the operation. Please check the below sample for your reference. 

 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Pivot_Table643005331 

 

Please let us know if you have concern. 

 

Regards, 

Sivamathi.