PivotTable pagefields filter value

[vasanth]

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]

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. 

 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/PivotTable_(2)1072380945.zip   

  

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.