When experiencing system timeouts with case reports, which two recommendations should a consultant make?

When addressing system timeouts with case reports, one effective recommendation is to remove formula fields from the filter criteria. Formula fields can significantly impact the performance of a report because they require real-time calculations during the report generation process. Each record must be evaluated to compute the formula, which can lead to increased processing time and potential timeouts, especially when dealing with large datasets. By excluding these fields from the filter criteria, the report can execute more efficiently, enhancing performance and reducing the likelihood of timeouts.

The option regarding removing unnecessary columns from the reports is also beneficial, as it can streamline the data being processed. However, in this context, the removal of formula fields is a more direct approach to mitigate timeouts, making it a primary recommendation.

The other options may not directly address the cause of timeouts as effectively in all scenarios. For example, removing date boundaries can actually narrow down the dataset to be processed and improve performance in some cases. Similarly, removing dashboards tied to long-running reports might help manage system resources but does not directly optimize the report's execution itself.