Filter List Missing Values With Large Amount of Data

RELATED TO:

AUTHOR: Marin Bratanov

DATE POSTED: November 15, 2017

PROBLEM

The possible values in the filter window is limited and does not include (load) the entire list of all items available from the data source.

DESCRIPTION

The ListBox control used in the FilterWindow has a default max value of items set to 1000 items. If you have more items they will not be shown/loaded.

Also, these items cannot be sorted, so you may not see them in the order you may expect (e.g., alphabetically), but as they come from the data source.

SOLUTION

Increase the SetConditionListCapacity property under the OLAP settings. For example:

<telerik:RadPivotGrid runat="server" ID="RadPivotGrid1">
    <OlapSettings SetConditionListCapacity="23456">
    </OlapSettings>
</telerik:RadPivotGrid>

More Resources

  • Forums

    Find answers to thousands of questions or reach out to our active community.

  • Demos

    Browse 1,200+ demos with source code covering basic and advanced scenarios.

  • Sample Applications

    Learn how to integrate the controls in real-world examples.

  • Feedback Portal

    Vote and follow the features you want to see added to Telerik UI for ASP.NET AJAX.

  • User Voice

    Get answers directly from the people who build the product.

  • Documentation

    Benefit from detailed help articles and API references for all controls.

  • Knowledge Base

    Learn how to achieve common scenarios from a multitude of tutorials and working examples.

  • Code Library

    Browse sample projects submitted by Telerik staff and community members.

  • Blog

    Stay up-to-date with the latest functionality, how-to articles and industry trends.

  • Release History

    Up-to-date release notes for all new features and improvements.