Download Free Trial

Pivot layout update

The data is loaded into pivot table. I just wanted to do some slice and dice without reload the data. I have used setReport to load the report, but, it’s reloading the report along with the data. Is there any other method can we use to change the slice of the report without  reload?
if so, In which event can we handle this.
2. How to catch drill down event? any event will be fired? Can we get the value of that clicked cell?
Thanks & Regards,

1 answer

Tanya Gryshko Flexmonster September 27, 2017

Hello, Sunilkumar.V,
Thank you for writing.
1. You can try changing the slice of the report without reloading via runQuery API call. This method allows rearranging of rows, columns and report filters. Please find an example:
As about related events, runningquery is triggered before data query is started. querycomplete is triggered after the data query was complete.
2. Please try celldoubleclick event which is triggered when a cell is double clicked on the grid. When this event is triggered, Cell Data Object is passed to the handler. This object contains the value of the clicked cell.
Let me know in case you have further questions.

Please login or Register to Submit Answer