This project has moved. For the latest updates, please go here.

facing issues while trying to add a row field from a page field - Pivot table

Jul 6, 2011 at 11:57 AM

i have few page fields in my pivot table and i am adding this page field as a row field. i am getting an error while trying to do this. Sample code below

 

pivotTable.PageFields.Add(pivotTable.Fields["XYZ"]);

pivotTable.DataOnRows = true;

pivotTable.RowFields.Add(pivotTable.Fields["XYZ"]);

 

when ever we add a row field which is available in page fields, this same field will be removed from page field and it adds up in the row field and the pivot table gets refreshes. Let me know how to handle this scenario in EPPlus. In excel dll it can be handled and as epplus is binary data i am not able to find the code for this scenario. Also there is no option for refreshing the data in pivot table with EPPlus dll.

Your help will be appreciated.

Thanks in advance.