PivotGrid - Setting Default STEP for specific fields.

[Mark]

Is there the ability to set the default STEP for a field that has not been used as an aggregate but is in the list for the user to select? We have an AGE field, and when the user drags it to either the ROW or COLUMN, the default STEP is 100. We need it to default to 10. Can we do this programmatically?

 

TIA.

[Nadya | Tech Support Engineer]

Hello, Mark,

Yes, it is possible to define the step value for DoubleGroupDescription by setting the Step property. It would be necessary to specify the PropertyName to point to your age field. You can do this in the following way:

DoubleGroupDescription unitPriceDescriptor = new DoubleGroupDescription() { PropertyName = "UnitPrice", Step = 10, GroupComparer = new GroupNameComparer() };
dataProvider.RowGroupDescriptions.Add(unitPriceDescriptor);

For more additional information you can check the following article: Using the LocalSourceDataProvider - RadPivotGrid - Telerik UI for WinForms

I hope this information is useful. If you have any other questions do not hesitate to ask.

Regards,
Nadya | Tech Support Engineer
Progress Telerik

[Mark]

In the code example above, it looks like you are adding the "UNITPRICE" programmatically to the ROW GROUP, which you are correct, we can do that. But we have a default set of ROWS/COLUMNS/AGGREGATES when the grid is displayed.  What we are experiencing is when the user drags the "AGE" field to the COLUMN or ROW, the default STEP is 100. Is there any way to change this default from 100 to 10 when the user drags that column into the COLUMN/ROW?

 

[Nadya | Tech Support Engineer]

Hello, Mark,

Thank you for providing clarifications.

To define the step when the user drags a column into column/row fields you can use the PrepareDescriptionForField event in the following way:

private void DataProvider_PrepareDescriptionForField(object sender, PrepareDescriptionForFieldEventArgs e)
{
    var description = e.Description as DoubleGroupDescription;
    if (description != null && description.PropertyName == "UnitPrice")
    {
        description.Step = 10;

    }
}

I hope this helps. If you have any other questions do not hesitate to ask.

Regards,
Nadya | Tech Support Engineer
Progress Telerik