How to move fields from "All Fields Area" to "Filter Area"

[Fabiana]

Hi Support!

I am evaluating RadPivotGrid, and I have one question about it: I am using RadPivotGrid1_NeedDataSource(), and the code is:

                  System.Data.DataTable mDataTable = ReturnDataTable();
                    (sender as RadPivotGrid).DataSource = mDataTable;

And I would like to move all fields that will be show in "All Fields Area"  to "Filter Area" in server side code. Is it possible? How to do it?

 

Thanks!

 

[Angel Petrov]

Hi,

In order to display a field in the filter fields section one should add it as a PivotGridReportFilterField. That said you can create the grid programmatically as explained here and define the PivotGridReportFilterFieldс. Have in mind that when following this approach you may need to per-request the pivot data source.

Regards,
Angel Petrov
Telerik