I am experiencing a persistent issue with an Interactive Report containing a large dataset (approx. 350k records). The report loads fine initially. However, when I apply a Control Break on a column (e.g., Company Name) and attempt to collapse the group header, the report enters an infinite loading state (spinning circle) and never resolves.
Troubleshooting Attempted:
- Initially, the Pagination Type was set to "Scroll". Suspecting a conflict between Scroll pagination and the offset required for the Control Break, I switched the Pagination Type to "Row Ranges X to Y of Z" (Page Pagination).
- Outcome: The issue persists even with Page Pagination. The spinner still hangs indefinitely upon collapsing a group.
Technical Observations:
- The issue seems specific to the "Collapse" action triggering a data fetch for the next group that never completes or returns a response the UI can handle.
Request: Has anyone encountered this freezing behavior on Control Break collapse with large datasets in recent APEX versions? Is there a known patch or a specific attribute setting required to handle breaks on large volumes efficiently?