FieldsWindow are creating unnecesary fields

[Guillermo]

Hi.

Actually i´m using a PivotGrid and when a FieldsWindow is displayed and the fields are offered to choose, some of them are created by the control.

How is possible to hide or desactivate them?

Thanks in advance.

[Angel Petrov]

Hello Guillermo,

In order to remove the auto-generated fields you can subscribe to the OnFieldCreated event and execute the following logic.

C#:

protected void RadPivotGrid1_FieldCreated(object sender, PivotGridFieldCreatedEventArgs e)
    {
        if (e.Field.UniqueName.Contains("Year") || e.Field.UniqueName.Contains("Quarter") || e.Field.UniqueName.Contains("Day") || e.Field.UniqueName.Contains("Month")
            || e.Field.UniqueName.Contains("Week") || e.Field.UniqueName.Contains("Minute") || e.Field.UniqueName.Contains("Hour")
            || e.Field.UniqueName.Contains("Second"))
        {
            RadPivotGrid1.Fields.Remove(e.Field);
        }
    }

Regards,
Angel Petrov
Telerik

 

 

[Guillermo]

Thank you for your answer, I´ll try it inmediatly.

Regards.

[Guillermo]

The fix is right.

Thanks again and regards