SAP Knowledge Base Article - Public

1696654 - Crystal Reports designer throws an error “Out Of Memory” while running the report

Symptom

  • Crystal Reports designer throws an error “Out Of Memory” while running the report
  • Report runs for a long time and then throws “Out Of Memory”

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013

Cause

  • Crystal Reports is 32bit application
  • Any 32 bit windows applications are limited to make use of  maximum 1.7 GB

Resolution

  1. Run the Crystal Reports and open the Task Manager side by side
  2. Check the memory consumed by Crystal Reports in Task Manager
  3. Check if Crystal Reports throws "Out Of Memory" error when memory is more than 1.5 GB
  4. Try to filter the data using record selection
  5. Filter the data at database level not at report level
  6. Make this filtration of data in such a way that the generated SQL contains WHERE clause so that query hits the database directly

Keywords

Out Of Memory, crystal report , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013