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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

PivotTable pagefields filter value

Thread ID:

Created:

Updated:

Platform:

Replies:

128864 Feb 13,2017 12:05 PM UTC Feb 14,2017 11:29 AM UTC ASP.NET Core 1
loading
Tags: XlsIO
vasanth
Asked On February 13, 2017 12:05 PM UTC

Hi..

 i am using syncfusion xlsio for reporting. i want to set default value in pivot table pagefilter in excel sheet

i tried lot of codes but not reflected in excel.

Example:

 //'Create Pivot Filter object to apply filter to page Fields
                        IPivotFilter filterValue = pivotTable.PageFields["CURRENCY"].PivotFilters.Add();
                        //Page Field would be filtered with value 'Binder'
                        filterValue.Value1 = mCurrency;

                        pivotTable.Fields["CURRENCY"].Items[0].Visible = true;
_____________________________
    IPivotField PageFieldPT = oSheet.PivotTables[ptblCount].PageFields[1];
    PageFieldPT.FilterValue = sDefaultPartnershipType;
   PageFieldPT.PivotFilters.Add(PivotFilterType.ValueEqual, PageFieldPT, sDefaultPartnershipType,null);

Thanks
Vasanth R

Abirami Varadharajan [Syncfusion]
Replied On February 14, 2017 11:29 AM UTC

Hi Vasanth, 
 
We are unable to reproduce the issue. We have prepared the sample as per your requirement and the sample can be downloaded from the following location. 
 
  
If your requirement is not met, then kindly modify and share us the issue reproducing sample. This will be helpful for us to provide prompt solution at the earliest. 
 
Regards, 
Abirami. 


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.

Warning Icon 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.Close Icon

;