Drop Down Breaks When Clicked

[Val Jensen]

Hello,

I have a PivotChart that used to work, but for some reason it has stopped doing so. When I click the arrow to expand the data, the whole table appears to crash. Here is a link to YouTube with video of the issue happening: https://youtu.be/bdOjWUMhf20

Here is the code I am using for this particular PivotTable (the page has four of them, but only this one expands):

var pivotTableObj3 = new ej.pivotview.PivotView({

                dataSourceSettings: {

                    dataSource: data,

                    expandAll: false,

                    showGrandTotals: false,

                    values: [

                        { name: 'crew_production', caption: 'Units Completed' },

                        { name: 'estimated_labor_budget', caption: 'Estimated Labor Cost' },

                        { name: 'st_hours', caption: 'Reg Hours' },

                        { name: 'actual_employee_st_cost', caption: 'Actual Labor Reg' },

                        { name: 'ot_hours', caption: 'OT Hours' },

                        { name: 'actual_employee_ot_cost', caption: 'Actual Labor OT' },

                        { name: 'Total_Labor_Cost', caption: 'Total Labor Cost', type: 'CalculatedField' },

                        { name: 'Labor_Variance', caption: 'Labor Variance', type: 'CalculatedField' }

                    ],

                    filters: [],

                    rows: [

                        { name: 'date', caption: 'Schedule Date' },

                        { name: 'item', caption: 'Item' }

                    ],

                    filterSettings: [],

                    sortSettings: [

                        { name: 'date', order: 'Descending' }

                    ],

                    formatSettings: [

                        { name: 'date', type: 'date', format: 'MMM dd, yyyy' },

                        { name: 'crew_production', format: '#,###' },

                        { name: 'estimated_labor_budget', format: '$#,###.00' },

                        { name: 'st_hours', format: '#,###.00' },

                        { name: 'actual_employee_st_cost', format: '$#,###.00' },

                        { name: 'ot_hours', format: '#,###.00' },

                        { name: 'actual_employee_ot_cost', format: '$#,###.00' },

                        { name: 'Total_Labor_Cost', format: '$#,###.00' },

                        { name: 'Labor_Variance', format: '$#,###.00' }

                    ],

                    calculatedFieldSettings: [

                        { name: 'Total_Labor_Cost', formula: '"Sum(actual_employee_st_cost)"+"Sum(actual_employee_ot_cost)"' },

                        { name: 'Labor_Variance', formula: '"Sum(estimated_labor_budget)"-("Sum(actual_employee_st_cost)"+"Sum(actual_employee_ot_cost)")' }

                    ]

                },

                gridSettings: gSettings,

                allowCalculatedField: true,

                showTooltip: false,

                aggregateCellInfo: function(args) {

                    if (args.value === Infinity) {

                        args.value = 0;

                    }

                },

                height: objHeight

            });

dataSource is being captured with the ej.data.JsonAdaptor, and gridSettings is just setting things like column width, row height, text wrapping, etc.

When I add showFieldList: true, I can then add/remove rows, which will then display the expanded data, but trying to click the arrow to collapse causes it to crash again.

Please let me know if there is something I am doing wrong in the code, or if it may be the data that is coming in. Thank you!

[Manikandan Murugesan]

Hi Val Jenson,  

   

We are unable to reproduce the problem at our end. Please refer the following sample.  

Sample: https://stackblitz.com/edit/1pbjfp?file=index.ts 

   

If still the problem exists, kindly reproduce the problem in the above provided sample and revert us (or) send your sample that replicating the problem. This would be a helpful for us to investigate the reported problem at our end and provide the solution at earliest.  

   

Regards,  

Manikandan  

[Val Jensen]

Hi Manikandan,

Below is a link to a video of your provided sample breaking as well. I tested your sample on both Chrome and Microsoft Edge.

https://youtu.be/yfQtKI2EtmM

I did not modify your code at all for this break to happen. It looks similar to my issue, but not sure if it's the same thing.

Please advise.

Thanks,

Val

[Manikandan Murugesan]

Hi Val Jenson, 

We are unable to reproduce the reported problem at our end. But we found that the component refreshes twice while drill operation. And we suspect this might be the reason for the reported problem. 

So, we have considered this as a bug “Component flickers on drill operation” and logged a defect report in our database. And the fix will be available on June 8 weekly patch release. You can track the same in the following link. 

https://www.syncfusion.com/feedback/25828/component-flickers-on-drill-operation 

 

We appreciate your patience until then. 

Regards, 

Manikandan 

[Manikandan Murugesan]

Hi Val Jenson, 

We are glad to inform you that the fix for the issue “Component flickers on drill operation” has been included in the weekly release (v19.1.0.67). Kindly refer the following sample. 

Sample: https://stackblitz.com/edit/hyqetb 

We thank you for your support and appreciate your patience in waiting for this release. Please contact us if you would require any further assistance. 

Regards, 

Manikandan