Hello Team,
Why does table pagination show “of many” instead of the total number of pages? I am using open source BI helical insight enterprise edition version 5.0. I have used the adhoc drag drop interface to create a tabular report.
Thanks,
vema.
Hello,
This is the expected behaviour in table reports. Data is loaded page by page to improve performance, especially when the dataset is large. Because of this, the system does not calculate the total number of pages in advance, so it shows “of many” instead of an exact page count.
If required, the total number of pages can be displayed by enabling the “Fetch All Records” option. However, this loads all the data at once, which can slow down report performance, so it is generally not recommended.
You can refer to the below blog for more details on table pagination:
Thank You,
Helical Insight.