How can I turn Summary on or off at runtime on a Pivotgrid.

[George Busby]

I want to be able to change with pivot row has summary rows shown at run time. I tries to use

 PivotGridControl1.PivotRows.Item(i).ShowSubTotal = False Where i= the index of the pivot row I want to run off summaries, but nothing happens. I have tries to use the Refresh command but it does not remove the summary row.

[Thirupathi Bala Krishnan]

Hi George, 

 

Sorry for the inconvenience caused.

We are able to reproduce the reported issue “Unable to hide the row and column subtotal values at runtime” and we have logged an issue report for the same. We will provide the patch file for the reported issue on 23^rd  December, 2019. The fix will be available in our next main release Volume 4 SP1 release which is scheduled to be rolled out in February, 2020.

You can track the status of this report through the following feedback link,    

https://www.syncfusion.com/feedback/10783/unable-to-hide-the-row-and-column-subtotal-values-at-runtime  

      

If you have any more specification replication procedure or a scenario to be tested you can add it as a comment in the portal.  

Please let us know if you need any further assistance. 

 

Regards,
Thirupathi B. 

[Thirupathi Bala Krishnan]

Hi George, 

Sorry for the inconvenience caused. 

We have fixed the reported issue –“Unable to hide the row and column subtotal values at runtime”. Still we need to ensure the stability of our pivot gird control from our end. So we will provide the patch file for the reported issue on 31^st December, 2019. 

We appreciate your patience until then. 

Regards,
Thirupathi B. 

[Thirupathi Bala Krishnan]

Hi George,  

Thanks for your patience.

We have fixed the reported issue –“Unable to hide the row and column subtotal values at runtime”. Now the row and column subtotals are displayed based on the ShowSubTotals property of PivotItem. Please find the patch file from the following location:     

     

V17.4.0.39 

Recommended approach – exe will perform automatic configuration                

Please find the patch setup here:                                      

http://syncfusion.com/Installs/support/patch/17.4.0.39/869331/F149928/SyncfusionPatch_17.4.0.39_869331_12312019085628800_F149928.exe 

 

Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment                                 

Please find the patch assemblies alone from:   

http://syncfusion.com/Installs/support/patch/17.4.0.39/869331/F149928/SyncfusionPatch_17.4.0.39_869331_12312019085628800_F149928.zip 

                

Please find the Nugets from the below location:                

http://syncfusion.com/Installs/support/patch/17.4.0.39/869331/F149928/SyncfusionNuget_17.4.0.39_869331_12312019085628800_F149928.zip 

                  

 

                

NOTE: 
You can change how you receive bug fixes by navigating to the following link and updating your preferences.
https://www.syncfusion.com/support/directtrac/patches             

              

Disclaimer:                               

Please note that we have created this patch for the version 17.4.0.39 specifically to resolve the issues reported in this forum #149928. If you have received other patches for the same version for other products, please apply all patches in the order received. This fix will be included in our upcoming  Volume 4 SP1 release which will be rolled out by February, 2020.

Please let us know if you need any further assistance. 

Regards,
Thirupathi B.