Set Default Filter Values

[Kevin]

Is it possible to set default values for filters within PivotGrid?

For example, within my PivotGrid I have a Column Field 'Year', and I want this to be automatically filtered by the past 2 years on load. 

[Viktor Tachev]

Hi Kevin,

In order to set filters in RadPivotGrid that are applied initially you could use the PreRender event and define the values that would be used in the filter. You could specify the filter with the
FilterByLabel() method. If you would like you could check out the example of using the method in this article.


Regards,
Viktor Tachev
Telerik

 

 

[Admins]

Hi,

Thank you for this link but I am not succeed to apply a filter on the year when this field is defined as PivotGridReportFilterField

If I want to select the current year, how can I do that?

Regards
A

[Viktor Tachev]

Hello,

You could try the FilterByLabel and FilterByValue methods of the RadPivotGrid.

FilterBylabel:

protected override void OnPreRender(EventArgs e)
{
    base.OnPreRender(e);
    RadPivotGrid1.FilterByLabel(PivotGridFilterFunction.Contains, RadPivotGrid1.Fields["Cost"], "filter value");
}

protected override void OnPreRender(EventArgs e)
{
    base.OnPreRender(e);
    RadPivotGrid1.FilterByLabel(PivotGridFilterFunction.IsNotBetween, RadPivotGrid1.Fields["Cost"], "filter value", "beetween filter value");
}

FilterByValue:

protected override void OnPreRender(EventArgs e)
{
    base.OnPreRender(e);
    RadPivotGrid1.FilterByValue(PivotGridFilterFunction.BeginsWith,
        RadPivotGrid1.Fields["Line"],
        RadPivotGrid1.Fields["Total"] as PivotGridAggregateField,
        "filter value");
}

protected override void OnPreRender(EventArgs e)
{
    base.OnPreRender(e);
    RadPivotGrid1.FilterByValue(PivotGridFilterFunction.IsBetween,
        RadPivotGrid1.Fields["Line"],
        RadPivotGrid1.Fields["Total"] as PivotGridAggregateField,
        "filter value",
        "between filter value");
}

Regards,
Viktor Tachev
Telerik