I know this but my question is different. Say I have 10K records in a table and this table grows in size gradually over time. How would I make I sure that report queries all the records and not just a hard coded value e.g. 10K
Hi, In that case, just enable pagination in your report. whne pagination is enabled, then max row count is ignored an dit will pull all records unless timed out due to very very high no of records ... so you may have to optimize that if needed.