function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
pavan kumar 1156pavan kumar 1156 

how can i improove optimaization of a report?

since Christmas myself and no of other users across multiple business lines have noticed that reports are taking a lot longer to run, often timeout any optimization to improve this?
Raj VakatiRaj Vakati
Please refer this link 

https://developer.salesforce.com/docs/atlas.en-us.salesforce_reportperformance_cheatsheet.meta/salesforce_reportperformance_cheatsheet/reportperformance_cheatsheet.htm​

https://resources.docs.salesforce.com/188/latest/en-us/sfdc/pdf/salesforce_reportperformance_cheatsheet.pdf​

https://help.salesforce.com/articleView?id=improving_report_performance.htm&type=5​

 
  • When filtering, use the equals or not equal to operators instead of contains or does not contain. For example, use Account Owner equals John James, not Account Owner contains John. Choose AND rather than OR for filter logic
  • To narrow your report’s date range, use time frame filters. For example, use Last 30 Days instead of Current FY.
  • Set time frame filters by choosing a Date Field and Range to view. Only records for that time frame are shown.
  • Reduce the number of fields in the report by removing unnecessary columns or fields.
  • If you receive an error message saying that your activity report has too many results, filter on a picklist, text, or date field. Alternatively, rerun the report using a different activity data type such as “Activities with Accounts” or “Activities with Opportunities”.
  • Add time filters, scope filters, and filter criteria to the report to further narrow the results.