Get Free Trial

Grand Totals not visible when data is big

Answered
Ronaldo C asked on June 17, 2022

Hello Flexmonster Team,
I have the following problem:
When having a lot of data in the table, it’s a bit difficult to see the grand totals, since we have to scroll a lot of rows/columns.
I feel like this can be solved by putting the grand totals in the top or left, but I notice a lot of threads already ask for such feature as well.
So my question is basically:

  • Any plans to add the feature?
  • Do you have any other solution that can help alleviate the problem?

Many thanks,
Ronaldo

3 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster June 17, 2022

Hello, Ronaldo,

Thank you for reaching out to us.

Currently, we do not have plans to introduce this feature. It is because of the current complex architecture responsible for rendering the grid.
We recommend using one of the following workarounds:

  1. Using the scrollToColumn and scrollToRow API calls provided by Flexmonster to scroll to the Grand Totals. Please check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/rju23gza/9/ 
  2. Alternatively, you can implement your own Totals Row outside the component using the getData API call. It allows retrieving data from the grid and is usually used to integrate with third-party charting libraries. You can use it to retrieve desired grand totals. You can check the following sample illustrating getting grand totals: https://jsfiddle.net/flexmonster/dj0b97y1/ 

Feel free to contact us if other questions arise.

Kind regards,
Nadia

Public
Ronaldo C June 20, 2022

Hello Nadia,
Thanks for the answers.
Unfortunately, I notice that the workaround for scrollToColumn and scrollToRow work in Chrome but doesn’t work properly in Firefox. Can you have a check on it and see what’s going on?
Regards,
Ronaldo

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster June 21, 2022

Hello,

Thank you for reporting the issue.

We will take a look at the described behavior and provide a fix with our minor release with the ETA July 11th.

You are welcome to write to us in case further questions arise.

Kind regards,
Nadia

Please login or Register to Submit Answer