Make the labels in the Aggregates area more uniformly legible

[Karen]

Is there anyway to make label in the Aggregates area more uniformly legible?

My PivotGrid has a lot of column to display.
 I make some changes: 
 
PivotAggregateDescriptorContainer pivotAggregateDescriptorsAreaContainer = radPivotGrid.PivotGridElement.AggregateDescriptorsArea;
pivotAggregateDescriptorsAreaContainer.FixedItemSize = true;

And implement method:
void radPivotGrid_AggregateDescriptorElementCreating(object sender, AggregateDescriptorElementCreatingEventArgs e)
{
    PivotAggregateDescriptorElement aggregateElement = e.AggregateDescriptorElement;
    aggregateElement.TextWrap = true;
    aggregateElement.DrawFill = false;
}

The issue is that PivotAggregateDescriptorContainer  overlap PivotColumnDescriptorContainer, It doesn't see "Aggregates" label.

Please help

Thank you.

[Dess | Tech Support Engineer, Principal]

Hello, Karen,

Note that the PivotGridElement.ColumnWidth property is appropriate for adjusting the aggregate area's width in order to fit the content in it.

Before:

After:

  this.radPivotGrid1.PivotGridElement.ColumnWidth = 150;

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

[Nhi]

I have many columns in report.  User cannot tell what aggregates are on report unless the hover.

I don't want to set column width.  If I widen so much horizontally that the format of report is bad. 

Is there any way I set vertically?  Or do something ? Please look the attached file.  

 

Thank you
 

[Dess | Tech Support Engineer, Principal]

Hello, Nhi,  

It seems that the mentioned file is missing. However, you can manage the PivotGridElement.ColumnHeaderHeight property and wrap the text in the aggregates as follows:

        public RadForm1()
        {
            InitializeComponent();
            this.radPivotGrid1.PivotGridElement.AggregateDescriptorElementCreating += PivotGridElement_AggregateDescriptorElementCreating;
        }

        private void RadForm1_Load(object sender, EventArgs e)
        { 
            this.ordersTableAdapter.Fill(this.nwindDataSet.Orders);

           
            this.radPivotGrid1.RowGroupDescriptions.Add(new DateTimeGroupDescription() { PropertyName = "OrderDate", Step = DateTimeStep.Year, GroupComparer = new GroupNameComparer() });
            this.radPivotGrid1.RowGroupDescriptions.Add(new DateTimeGroupDescription() { PropertyName = "OrderDate", Step = DateTimeStep.Quarter, GroupComparer = new GroupNameComparer() });
            this.radPivotGrid1.ColumnGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "EmployeeID", GroupComparer = new GrandTotalComparer() });
            this.radPivotGrid1.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "Freight", AggregateFunction = AggregateFunctions.Sum });
            this.radPivotGrid1.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "Freight", AggregateFunction = AggregateFunctions.Average });
            this.radPivotGrid1.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "OrderDate", AggregateFunction = AggregateFunctions.Min });
            this.radPivotGrid1.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "Freight", AggregateFunction = AggregateFunctions.Max });
            this.radPivotGrid1.FilterDescriptions.Add(new PropertyFilterDescription() { PropertyName = "ShipCountry", CustomName = "Country" });
           
            this.radPivotGrid1.DataSource = this.ordersBindingSource;

            this.radPivotGrid1.PivotGridElement.ShowFilterArea = true;
            this.radPivotGrid1.PivotGridElement.FilterAreaHeight = 45; 

            PivotAggregateDescriptorContainer pivotAggregateDescriptorsAreaContainer = this.radPivotGrid1.PivotGridElement.AggregateDescriptorsArea;
            pivotAggregateDescriptorsAreaContainer.FixedItemSize = false; 
            this.radPivotGrid1.PivotGridElement.ColumnHeaderHeight = 60;
        }

        void PivotGridElement_AggregateDescriptorElementCreating(object sender, AggregateDescriptorElementCreatingEventArgs e)
        {
            PivotAggregateDescriptorElement aggregateElement = e.AggregateDescriptorElement;
            aggregateElement.TextWrap = true;
            aggregateElement.DrawFill = false;
            aggregateElement.AutoSize = false;
            aggregateElement.Size = new Size(50, 50);
        }

I believe that it would be suitable for your case.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik