Initially collapse fields dragged from fieldlist

[Sjoerd]

Great news to be able to use pivotgrids!  Some questions though:

When I drag a field from the fieldlist into the row or column area, it is initially show expanded. Is it possible to initially show it collapsed?

Thanks
Sjoerd

[Jack]

Hello,

Thank you for your feedback. 

Currently it is not possible to collapse/expand rows and groups when data changes. However it seems to be a powerful feature and I added it in our issue tracking system. Use this link to follow the issue status. I updated your Telerik points for this suggestion. We will try to adjust our API to allow this scenario in our upcoming release.

If you have any other questions, do not hesitate to as

All the best, Jack
the Telerik team

[Sjoerd]

Thanks for your prompt reply.

In that case, wouldn't it be better to initialy collapse groups by default and let the user choose whether or not ot expand one or more groups? 

That would be in line with Excel and SQL. The extra property for opening expanded could then be added in some later version, but the component then at least behaves as most users expect, especially with larger lists.

I tried to find a work-around for now, but could not see how to access the fields that are included in the pivotgrid, let alone how to expand/collapse them. Surely an oversight on my behalf. Any chance you can point me in the right direction?

Thanks
Sjoerd

[Jack]

Hi Sjoerd,

Directly to your questions:

1. Our current implementation is designed to show rows expanded by default. Our tests indicate that MS Excel behaves exactly the same way. However, your suggestion makes sense and we will consider changing this behavior. In any case we will add an API that allows changing it in a simple way.

2. You can access all group fields (rows and columns) by using the ColumnRootGroup and RowRootGroup properties of PivotGridElement. Consider the sample below:

foreach (PivotGroupNode node in this.radPivotGrid1.PivotGridElement.RowRootGroup.Children)
{
    node.Expanded = false;
}

However, there is no event that allows changing groups expanded state when a field is being added. We will improve our documentation and API for our first stable release.

Should you have other questions, do not hesitate to contact us.

Kind regards,
Jack
the Telerik team

[Sjoerd]

Thanks Jack,

It seems that your Excel behaves different from mine (hidden feature, I guess). I just tried this in Excel again, and when I drag a field to the row or column area it is consistently displayed as collapsed. That is regardless whether I drag the field to a row/column label are within the field list or directly on the grid area.

I am using Excel 2010, and the data source is an Analysis Services cube. Could that be the difference?

For now I will make your code available to the user via some control. The way forward it would be good to have an event to capture the adding, changing and removing of fields from the rid.

Thanks so far,
Sjoerd

[Jack]

Hello Sjoerd,

I am posting here a video demonstrating the behavior on my side. I am using Excel 2010 with default settings. Maybe there is an option that specifies this behavior and we plan to proceed the same way. We will allow the user to specify the behavior or RadPivotGrid.
 
Greetings,
Jack
the Telerik team

[Sjoerd]

Weird indeed. However, looking at your video I realized the source of the miscommunication.

You are correct that all root values are displayed by default when you drag a new field into the grid.

However, I was dragging a dimension field with a user hierarchy into the grid. Here too, all values at the top level are immediately shown, but none of these is expanded by default. In the attached example you can see I dragged the publication date on the grid, which initially display only year values (1978 was manually expanded by me). With the Telerik pivotgrid the entire hierarchy is initially expanded down to the day level.

This may sound a trivial thing, but especially with OLAP-based grids the number of nodes in a dimension can be huge.

Anyway, I'm happy with the proposed approach.

Thanks
Sjoerd

[Jack]

Hi Sjoerd,

Thank you for these details. Now I understand the case. We will consider it when implementing the feature.

Fell free to contact us if you have other questions.
 
Greetings,
Jack
the Telerik team

[Luis Gilbert]

Is this functionality included in 2013 Q2 release?
Perhaps, a new event was added to control initial collapse functionality?

[Peter]

Hi Luis,

Thank you for your question. In Q1 2013 we included an event named GroupExpandedChanged.

I hope this event will be useful for your scenario.

Regards,
Peter
Telerik

[Madhuri k. chaube]

I was generate a report in telerik using toggle visibility but it shows all the information in expanded form and I want this information Initially in collapse form and after clicking on '+' it will expanded.....plz give a suggestion its urgent........

[Dess | Tech Support Engineer, Principal]

Hello Madhuri,

Thank you for contacting Telerik Support.

According to the provided information, it seems that your question is related to the Telerik Reporting product. As this forum is purposed to handle questions about Telerik UI for WinFoms, I would kindly ask you to post your question in the Reporting forum. Thus, you can contact the Telerik Reporting community and deal with the difficulty that you are experiencing.

Thank you for your understanding.

Regards,
Desislava
Telerik

 

 

[Prabhu]

Hello Sir,
 I've more than three sub header in pivodgrid  when i click 1st headercell its show next header with collapse button then others.. like to end...

but i need , when i'm  expand 1st click in header its show all sub header  upto datafield without expand/collapse button.. is it possible...
please tell me soon

[Madhuri k. chaube]

Currently it is not possible to collapse/expand rows and groups when data changes. However it seems to be a powerful feature .

But I will try to solve it soon....

thanx

[Madhuri k. chaube]

Ok and Thank Tou for suggession

[George]

Hello,

Thank you for writing.

Prabhu, I am not entirely certain what you are trying to achieve. If you want to hide the expand/collapse buttons you can use GroupElementFormatting​:

void pivotGrid_GroupElementFormatting(object sender, PivotGroupElementEventArgs e)
{
    e.GroupElement.ExpanderElement.Visibility = Telerik.WinControls.ElementVisibility.Collapsed;
}

If this is not what you mean, I would like to kindly ask you to provide me with more details about what you are trying to achieve.

Let me know if you need further assistance.

Regards,
George
Telerik

 

 

[Prabhu]

Thanks to reply..
Is it possible to decorate(change fore color) header cell in Pivotgrid..

ref: Attached image marked in red color

[Ivan Todorov]

Hello Prahbu,

It is possible to decorate all elements in RadPivotGrid using the appropriate events. In particular, formatting the headers can be achieved by handling the events as shown below. Note that they are formatting the two different types of headers. You might find the following help article useful as it describes the element structure of RadPivotGrid.

public Form1()
{
    InitializeComponent();
    this.radPivotGrid1.GroupElementFormatting += radPivotGrid1_GroupElementFormatting;
    this.radPivotGrid1.GroupDescriptorElementCreating += radPivotGrid1_GroupDescriptorElementCreating;
}

//fires for the elements in the Column descriptors area and for the Row descriptors area
void radPivotGrid1_GroupDescriptorElementCreating(object sender, Telerik.WinControls.UI.GroupDescriptorElementCreatingEventArgs e)
{
    if (e.Axis == Telerik.Pivot.Core.PivotAxis.Columns)
    {
        e.GroupDescriptorElement.BackColor = Color.Red;
        e.GroupDescriptorElement.NumberOfColors = 1;
    }
}

//fires for the Column headers and for the Row headers
void radPivotGrid1_GroupElementFormatting(object sender, Telerik.WinControls.UI.PivotGroupElementEventArgs e)
{
    if (e.GroupElement.Data.Axis == Telerik.Pivot.Core.PivotAxis.Columns)
    {
        e.GroupElement.BackColor = Color.Lime;
    }
}

I hope you find this useful.

Regards,
Ivan Todorov
Telerik