Skip to Content
avatar image
Former Member

Running out of Memory Crystal Reports V

At the moment I am just trying to write a report.

When I preview it runs for about 25 minutes and then says it is out of memory. i only have 3 fields on the report so far. One is a Group header, one a Group footer.

it's querying an MS-SQL server database that has 480+ million records.

It's normalized and I'm accessing three tables, one field from each record.

I've googled and searched here. I haven't found anything that discusses how to fix this. Surely, CR can handle a large dataset like this. (Surely?) :-)


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 29, 2017 at 04:49 PM

    1. Open your report

    2. Go Database > Show SQL Query

    3. Copy the SQL Query

    4. Create a new report connecting to the same database, but this time use "Add Command" option

    5. Paste the SQL query to the Command window and modify the first line - use "Select Top 1000000" instead of the simple "Select"

    6. Refresh the report. If it works increase the number

    Add comment
    10|10000 characters needed characters exceeded

  • May 26, 2017 at 07:34 PM

    Can we get some more information?:

    1. Fields could be just numeric fields or could be Memo type fields up to 2048 characters long. It makes a difference for memory consumption

    2. Three tables are linked or not? It also makes a difference.

    Run report with Task Manager open and monitor memory consumption. If memory goes above 1.7 GB then it probably hits 2 GB Windows limitation for 32 bit application.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      As promised, here are the results of 'out of memory' test:

      Task manager shows:

      1,626,156k at the time the Crystal pop's up the 'Out of memory' box.

      Crystal shows it stopped at:
      76,115,046 rows

      I will try limiting the data set. The problem with this, even if it works is, I need to be able to run reports on all the data. if it's 400 million, or 800 million rows. :-)

  • May 29, 2017 at 03:49 PM

    That is what I expected - 1.6 GB definetely means you are reaching 2GB Windows limitation. No ways to change the limit.

    Another workaround solution is to reduce the number of columns in the report.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I just spent the last 40 minutes searching for how to limit the results of a dataset per you reply:

      You can also limit your dataset and test for 1 million records, 10 million records, 100 million records.

      I can't find it anywhere. Can you explain how to limit how many records are queried for on the MS-SQL backend?