reduce recordset

Hello Adriano,

Thank you for reaching out to us.

Kindly note that expanding cells is a heavy operation that requires many resources. It is expected to be processed slowly when performed over large data sets.

We recommend defining the expands the object of the Slice when setting the report. It allows expanding not all fields but only the necessary ones. This will significantly increase the performance.

The idea is to avoid using the expandAll or expandAllRows property, but instead use expands.rows array. For example, you can define expands for the first few rows or columns. Please feel free to check the following JSFiddle: https://jsfiddle.net/flexmonster/x9ouy7a8/.

Alternatively, users can expand the rows one by one by clicking on the expand arrow.

Please let us know if it works for you. You are welcome to contact us if other questions arise.

Kind regards,
Nadia

Hello Adriano,

Thank you for the response.

We want to explain that expanding the cells with 10,000 grouped records and 6 fields is a heavy operation because it is performed entirely in the browser and relies on the user's machine resources. Since this process significantly impacts performance, Flexmonster has an internal time limitation for the execution of the expandAll property or expandAllData() API call. By default, it is set to 9000 ms, but you can increase the waiting time using the expandExecutionTimeout property of the Options object. For example:

report: {
   options: {
     expandExecutionTimeout: 60000 // it is set in milliseconds
   }
}

You can find more details in our documentation: https://www.flexmonster.com/api/options-object/#expandexecutiontimeout.

Please let us know if further questions arise.

Kind regards,
Nadia

Hello Adriano,

Hope you are doing well.

We were wondering if you had a chance to test a suggested approach. Could you please confirm if it works for you?

Looking forward to hearing your feedback.

Kind regards,
Nadia