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.

Option "ShowSubTotal" on PivotItem set to "false" not working

Thread ID:

Created:

Updated:

Platform:

Replies:

123804 Apr 22,2016 07:06 AM Apr 25,2016 04:38 AM ASP.NET MVC 1
loading
Tags: PivotGrid
André Secco
Asked On April 22, 2016 07:06 AM

I'm using a Web API to load the data in the Pivot Grid. When defining columns and lines patterns in the method "BindDefaultData". Some of the lines I do not want to appear subtotals (as are items that have only one record). Even to set the property "ShowSubTotal = false", the subtotal keeps popping up. The following code:


private PivotReport BindDefaultData()
{
            PivotReport pivotSetting = new PivotReport();
            pivotSetting.PivotRows.Add(new PivotItem { FieldMappingName = "Date", FieldHeader = "Date", TotalHeader = "Total", ShowSubTotal = false });
            pivotSetting.PivotRows.Add(new PivotItem { FieldMappingName = "State", FieldHeader = "State", TotalHeader = "Total", ShowSubTotal = false });
            pivotSetting.PivotColumns.Add(new PivotItem { FieldMappingName = "Product", FieldHeader = "Product", TotalHeader = "Total", ShowSubTotal = false });
            pivotSetting.PivotColumns.Add(new PivotItem { FieldMappingName = "Country", FieldHeader = "Country", TotalHeader = "Total", ShowSubTotal = false });
            pivotSetting.PivotCalculations.Add(new PivotComputationInfo { CalculationName = "Amount", Description = "Amount", FieldHeader = "Amount", FieldName = "Amount", Format = "C", SummaryType = Syncfusion.PivotAnalysis.Base.SummaryType.DoubleTotalSum });
            return pivotSetting;
}


Another option I like is that in some lines I could have the option to not merge the cells were equal, instead repeat the contents of each cell. It is how to do this?

Sastha Prathap Selvamoorthy [Syncfusion]
Replied On April 25, 2016 04:38 AM

Hi Andre,

Thank you for contacting Syncfusion support.

We have created an incident to log an issue report on behalf of you. Our support engineer will assist you through incident. We request you to follow with the incident for further details.
 
https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents
 


Regards,
 

Sastha Prathap S. 



CONFIRMATION

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.

;