@Srivatsan Babu

The maximum number of records that can be extracted as part of scheduled reports is typically limited to 5,000 rows in Pega Platform version 8.8.x. This limit can be overridden by disabling pagination in the report definition settings, but increasing this limit may have performance impacts. For larger data extractions, it is recommended to implement BIX (Business Intelligence Exchange) for reporting large numbers of records. The maximum file size for exports is not explicitly mentioned in the provided context, so it may vary based on specific configurations and system capabilities.

Best practices for creating the reports is below :

https://docs.pega.com/bundle/platform-88/page/platform/reporting/best-practises-for-creating-reports-tsk.html