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"
</
Resources Buy Try