We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Showing Sub Totals in the pivot grid is Very slow

Thread ID:

Created:

Updated:

Platform:

Replies:

116897 Jun 26,2014 06:09 AM Mar 16,2018 01:42 PM Windows Forms 5
loading
Tags: PivotGridControl
Ashokraj
Asked On June 26, 2014 06:09 AM

Hi
I am working with pivot analyses grid, I Bind 1000 No’s of data’s as item source to pivot grid.
Also I added a pivot rows to the grid so that subtotal generated for each pivot item in the grid. I don’t want subtotal of each items of pivot rows so I hided it by use the following code


Me.GrdPivotGrd.ShowSubTotals = False


Its hanging the form and not responding error is raised. It’s happening only having large number of data's. If I have small number of data means its works perfectly. Please give any solution as soon as possible


Muthukumar Kalyanasundaram [Syncfusion]
Replied On June 27, 2014 09:03 AM

Hi Ashokraj,

 

Thank you for your interest in Syncfusion products.

 

We would like to let you know that the reported query can be resolved by  setting UseOldHiddenScrollLogic property as true. You can make use of code,

 

Code Snippet:

 

     GridControlBase.UseOldHiddenScrollLogic = true;

 

Please let us know if you have any concern.

 

Regards,

Muthukumar K


Ashokraj
Replied On June 30, 2014 02:25 AM

Hi Muthu
Thanks for your response
        I Used your code still its getting same error .
so that i used the following code
 
GrdPivotGrd.TableControl.ScrollCellInView(GrdPivotGrd.PivotEngine.RowCount - 1, GrdPivotGrd.PivotEngine.ColumnCount - 1)
Me.GrdPivotGrd.ShowSubTotals = True 
GrdPivotGrd.TableControl.ScrollCellInView(1, 1)
Now its working.
     I have another doubt's
              1) I want to increase the width of pivot rows header column .
              2) In my grid showgroupbytotal  is in false but still showing total for one items of pivot rows .
              3)  Fit the pivot row column header to its records.
Thanks & Regards
T.Ashokraj
   


Ashokraj
Replied On June 30, 2014 02:32 AM

Hi Muthu
   PFA for my requirement
Regards
T.Ashokraj

Attachment: PivotChangesRequirements_a0383e31.zip

Muthukumar Kalyanasundaram [Syncfusion]
Replied On July 2, 2014 10:05 AM

Hi Ashokraj,

 

Thank you for the update.

 

 

Query 1

Increase the width of Pivot rows header column

 

 

If you want to increase width of pivot rows header column by using the QueryColWidth event. You can use below code.

 

Code Snippet:

this.pivotGridControl1.TableControl.RowGroupDropArea.QueryColWidth += new Syncfusion.Windows.Forms.Grid.GridRowColSizeEventHandler(RowGroupDropArea_QueryColWidth);

this.pivotGridControl1.ShowGroupBar = true;

 

void RowGroupDropArea_QueryColWidth(object sender, Syncfusion.Windows.Forms.Grid.GridRowColSizeEventArgs e)

        {

            if (e.Index % 2 == 0)

            {

                e.Size = 192; // Customize your desired size

                e.Handled = true;

            }           

        }

 

 

 

Query 2

Hiding the group of row in pivot grid

 

If you want to hide the group of row in pivot grid, you can make use of below link.

Please refer to it.

 

 Link :  http://www.syncfusion.com/support/forums/windowsforms/pivotgridcontrol/116424

 

 

 

Query 3

Fit the Pivotrow column header

 

We implemented an feature module named “RowPivotsOnly mode” in Pivot grid for upcoming release. Please let us know if you are looking to create a UI like this layout. Please refer the below screenshot,

  http://www.syncfusion.com/downloads/support/directtrac/general/Pivotrowonly-1515146241.zip

 

 

Please let us know if you have any concern.

 

Regards,

Muthukumar K.


ouedraogo
Replied On March 16, 2018 01:42 PM

Hi Ashokraj,

 

Thank you for the update.

 

 

Query 1

Increase the width of Pivot rows header column

 

 

If you want to increase width of pivot rows header column by using the QueryColWidth event. You can use below code.

 

Code Snippet:

this.pivotGridControl1.TableControl.RowGroupDropArea.QueryColWidth += new Syncfusion.Windows.Forms.Grid.GridRowColSizeEventHandler(RowGroupDropArea_QueryColWidth);

this.pivotGridControl1.ShowGroupBar = true;

 

void RowGroupDropArea_QueryColWidth(object sender, Syncfusion.Windows.Forms.Grid.GridRowColSizeEventArgs e)

        {

            if (e.Index % 2 == 0)

            {

                e.Size = 192; // Customize your desired size

                e.Handled = true;

            }           

        }

 

 

 

Query 2

Hiding the group of row in pivot grid

 

If you want to hide the group of row in pivot grid, you can make use of below link.

Please refer to it.

 

 Link :  http://www.syncfusion.com/support/forums/windowsforms/pivotgridcontrol/116424

 

 

 

Query 3

Fit the Pivotrow column header

 

We implemented an feature module named “RowPivotsOnly mode” in Pivot grid for upcoming release. Please let us know if you are looking to create a UI like this layout. Please refer the below screenshot,

  http://www.syncfusion.com/downloads/support/directtrac/general/Pivotrowonly-1515146241.zip

 

 

Please let us know if you have any concern.

 

Regards,

Muthukumar K.


yes

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;