🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

getReport API does not return TableSizes

Christopher Phillips asked on June 7, 2019

Hi your documentation here https://www.flexmonster.com/api/report-object/ specifies tableSizes as a part of the model but getReport as demonstrated in your fiddle here http://jsfiddle.net/flexmonster/ft6revLs/ does not return that parameter. I only see dataSource, slice, and options.
We are looking to know how large the currently viewed dataset it so this information would be great to have access to.

4 answers

Vera Didenko Vera Didenko Flexmonster June 10, 2019

Hello, Christopher,
Thank you for writing to us.
We would like to point out that custom defined configurations are shown in the report. Default settings are automatically applied if nothing in their place had been specified and therefore are not included in the report object returned by an API call (exception: default slice).
In the JSFiddle example, the row and column sizes have not been changed, this is why the tableSizes parameter is not present in the returned report object. 
Please notice that if the width of a row/column is changed (for example, widened), then the tableSizes parameter is shown in the report object.
Please let us know if you have further questions.
Best Regards,

Christopher Phillips June 10, 2019

Thanks for the info Vera, I do have a follow up question: Is there a way for to find out how many rows and columns are currently displayed in the grid?  I was hoping the TableSizes object might be able to at least give us a count.  Since we are pushing the limits of the getData call I was curious if there was a way to find out a cell count ahead of time.

Vera Didenko Vera Didenko Flexmonster June 11, 2019

Hello, Christopher,
Thank you for your question.
Getting the number of cells on the grid is not supported at the moment.
We would like to point out that our team is working on a way for getData() to end more gracefully for the case described in the following thread: https://www.flexmonster.com/question/using-getdata-to-return-all-data-without-expanding-the-ui/
Would this work for you?
We are looking forward to hearing from you.
Best Regards,

Christopher Phillips June 11, 2019

Thanks Vera we will wait for your team to update that issue thank you!

Please login or Register to Submit Answer