Completed
Last Updated: 08 Mar 2018 09:10 by ADMIN
The DistinctValuesLimit property is available in our R1 2018 Release.
Approved
Last Updated: 06 Mar 2018 14:08 by ADMIN
ADMIN
Created by: Georgi
Comments: 2
Category: PivotGrid
Type: Feature Request
1
add a textbox which allows users to find matching distinc values when using report filters. Very valuable if you are dealing with many distinct values. 
Approved
Last Updated: 07 Feb 2018 10:34 by ADMIN
Approved
Last Updated: 18 Dec 2017 14:03 by ADMIN
Approved
Last Updated: 12 Dec 2017 12:01 by ADMIN
With the current implementation the top level header only visually appears as one cell, however it stretches the subheader column below (check PivotGrid(Now).png).


Looking the attach file,now the XAML is following:
<pivot:LocalDataSourceProvider.AggregateDescriptions>
                        <pivot:PropertyAggregateDescription PropertyName="AccValue" CustomName="total"/>
                        <pivot:PropertyAggregateDescription PropertyName="IncValue" CustomName="increased"/>
                 </pivot:LocalDataSourceProvider.AggregateDescriptions>

 <pivot:LocalDataSourceProvider.ColumnGroupDescriptions>
                        <pivot:PropertyGroupDescription PropertyName="SystemDeviceCode"/>
                    </pivot:LocalDataSourceProvider.ColumnGroupDescriptions>
the SystemDeviceCode column just use one column ,like the attach "PivotGrid(Now).png",when the text is long ,the first column "Total" is too wide .
I hope like the attach "PivotGrid(desired).PNG",the SystemDeviceCode column can span two columns.
     and the data struct:

 public class DayStruct1
    {
        public string HourNum { get; set; }
        public string SystemDeviceCode { get; set; }
        public double AccValue { get; set; }
        public double IncValue { get; set; }
        public DateTime Date { get; set; }
    }//
Declined
Last Updated: 09 Oct 2017 07:30 by ADMIN
Created by: Yehudah
Comments: 2
Category: PivotGrid
Type: Feature Request
0

			
Approved
Last Updated: 28 Jun 2017 06:08 by Yehudah
Created by: Yehudah
Comments: 0
Category: PivotGrid
Type: Feature Request
1
I want to create CustomDistinct aggregate, I did it successfully for LocalDataSourceProvider, and I need it also for QueryableDataProvider.

See: http://www.telerik.com/forums/custom-aggregate-for-queryabledataprovider
Approved
Last Updated: 21 Jun 2017 13:44 by ADMIN
Currently when a header value is empty the displayed text is "(blank)" regardless of the application's culture. Localize this value or allow the developer to set this value more easily.

If you want to manually localize the "(blank)" text you can define a RowHeaderTemplate and ColumnHeaderTemplate (or template selector) and replace the default text with its translation. You can do that via IValueConverter.
(http://docs.telerik.com/devtools/wpf/controls/radpivotgrid/styles-and-templates/templating-cells#using-custom-cell-and-header-templates)
Approved
Last Updated: 09 May 2017 09:07 by ADMIN
Approved
Last Updated: 13 Apr 2017 08:45 by ADMIN
Approved
Last Updated: 22 Mar 2017 09:51 by ADMIN
ADMIN
Created by: Stefan Nenchev
Comments: 1
Category: PivotGrid
Type: Feature Request
1

			
Approved
Last Updated: 22 Mar 2017 09:50 by ADMIN
ADMIN
Created by: Stefan Nenchev
Comments: 1
Category: PivotGrid
Type: Feature Request
1

			
Approved
Last Updated: 20 Mar 2017 16:24 by ADMIN
Approved
Last Updated: 16 Mar 2017 08:27 by Yehudah
I implemented it for me, but I will be glad to get it out of the box for all providers.

public class ExtendableLocalDataSourceFieldDescriptionsProvider : LocalDataSourceFieldDescriptionsProvider
{
    protected override ContainerNode GetFieldDescriptionHierarchy(IEnumerable<IPivotFieldInfo> fieldInfos)
    {
        var root = base.GetFieldDescriptionHierarchy(fieldInfos);
        var childs = from node in root.Children
                        let info = node.GetFieldInfoNode()
                        let dispAtt = info.FieldInfo.GetDisplayAttribute()
                        let groupName = dispAtt.GetGroupName()
                        where !string.IsNullOrEmpty(groupName)
                        group node by groupName into g
                        select new
                        {
                            g.Key,
                            g
                        };

        foreach (var group in childs.Reverse())
        {
            var newFolder = new ContainerNode(group.Key, ContainerNodeRole.Folder);
            foreach (var item in group.g)
            {
                root.Children.Remove(item);
                newFolder.Children.Add(item);
            }
        }
        return root;
    }

Note: GetFieldInfoNode & GetDisplayAttribute are extension methods.
Approved
Last Updated: 16 Mar 2017 08:21 by Yehudah
Created by: Yehudah
Comments: 1
Category: PivotGrid
Type: Feature Request
0
The implemented is very easily:

public class ExtendableLocalDataSourceFieldDescriptionsProvider : LocalDataSourceFieldDescriptionsProvider
{
    protected override ContainerNode GetFieldDescriptionHierarchy(IEnumerable<IPivotFieldInfo> fieldInfos)
    {
        var infos = from info in fieldInfos
                    orderby info.GetDisplayAttribute()?.GetOrder()
                    select info;
        return base.GetFieldDescriptionHierarchy(fieldInfos);
}

We will be glad to get it out of the box for all data providers.
Approved
Last Updated: 15 Mar 2017 13:44 by ADMIN
When I use QueryableDataProvider, the DisplayName of the aggregates is "Sum of MyField" etc., instead of the value of 'Pivot_AggregateSum' localization key.
Approved
Last Updated: 23 Feb 2017 14:07 by Yehudah
Created by: Yehudah
Comments: 0
Category: PivotGrid
Type: Feature Request
0
I have Written behavior to auto-format the AggregateDescription.StringFormat.

Now, I need to list all possible AggregateDescription's, with reference to their DLL.
if (e.Description is LocalAggregateDescription)
{
    (e.Description as LocalAggregateDescription).StringFormat = MyStringFormat;
}
else if (e.Description is QueryableAggregateDescription)
{
    (e.Description as QueryableAggregateDescription).StringFormat = MyStringFormat;
}
else if (e.Description is Other_XYZ_AggregateDescription)
{
    (e.Description as Other_XYZ_AggregateDescription).StringFormat = MyStringFormat;
}

But, if IStringFormattableAggregate was public, I would can write it better:
if (e.Description is IStringFormattableAggregate)
{
    (e.Description as IStringFormattableAggregate).StringFormat = MyStringFormat;
}
Approved
Last Updated: 23 Feb 2017 14:07 by Yehudah
As you did with PropertyInfoFieldInfo, which expose PropertyInfo property.

This can be very helpful to many custom logic based on the source PropertyInfo.
For example:

private static DisplayAttribute GetDisplayAttribute(QueryableFieldDescription fieldInfo)
{
    return fieldInfo.PropertyInfo.GetCustomAttribute<DisplayAttribute>();
}
Approved
Last Updated: 01 Feb 2017 16:51 by ADMIN
ADMIN
Created by: Polya
Comments: 0
Category: PivotGrid
Type: Feature Request
0