Skip to Content

CR 2016 Crashing for batch reports

We have recently installed CR 2016 in one of the customer’s PC running on Windows OS 10. The customer has issues running some of the batch reports (returns large number of data). The Crystal report shuts down at the start. However, the customer is able to run all other reports without any issues. We also tested the same batch reports on a PC with CR 2013 running on Windows OS 7. The reports were generated successfully but the CR crashes this time while closing the report. Please advise us on how to resolve this issue.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Feb 20, 2019 at 03:24 PM

    How much RAM and disk space is available on the computer where you're running the report? Crystal will do a lot of swapping to disk in its own temp files (not in the Windows Virtual Memory). So it sounds to me like it is running out of disk space. Also, when it crashes, it doesn't clean up these swap files. So first off, you need to look for "~*.rpt" and "*.tmp" files and delete them. This will potentially free up a lot of disk space.

    There are also a number of things that will cause Crystal to do a lot of swapping to disk based on the report configuration:

    1. On the Database tab of File>>Options, make sure "Use Indexes or Server for Speed" and Perform Grouping On Server" are both turned on.

    2. If you're using a command, make sure that it pulls ALL of the data for the report - don't join it to other tables or commands.

    3. Also if you're using a command or a stored procedure, DO NOT use the Select Expert to filter the data. Instead, use the Where clause in the command or do the filtering in the stored proc.

    4. Avoid connecting to multiple databases if possible.

    5. If you're joining tables together, avoid using Crystal functions and "if..then..else" statements in the Select Expert.

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 21, 2019 at 03:55 PM

    Thank you for your response.

    The computer has 90GB free disc space and 8GB RAM . We did cleaned up the temp files. Its still crashing.

    We couldn't set the suggested report options as the report doesn't come up at all. However we tried these options on a PC where the report come up but crashes at the close. The CR still crashed. We also tried to run it in compatibility mode and that didn't help either.

    Is there anything elae that we can do.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 21, 2019 at 04:04 PM

    Open Task Manager side by side with Crystal Reports 2016, go to Details tab and monitor the Memory consumption by crw32.exe process while opening the report in CR 2016. If it starts reaching 1.6-1.7 GB and crashing, it means CR reaches the Windows 32 bit app limit.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 21, 2019 at 09:41 PM

    Hi Prasanna,

    Try opening that report using CR 2013 on Windows 7 and start removing parts until it will save without crashing CR

    Start with all subreports and then whole sections and see if you can find the part causing CR to crash.

    It is possible the rpt file got corrupted some how while saving it to disk at some time or the hard drive had an issue.

    Any chance they have a back up?

    Is it one of your canned reports or something they wrote/modified?

    Don

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 22, 2019 at 04:10 PM

    This is the summary of the test that was done using multiple reports:

    File size # CPU % Ram% Status

    1: 188kb 12% 100mb opened

    2: 97kb 15% 127mb opened

    3: 1.6mb 3% 39.5mb opened

    4: 5.57mb 22% 12.5mb Crashes

    5: 5.5mb 13% 18.5mb Crashes

    So it never reached the upper limit 32 bit limit.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 27, 2019 at 04:38 PM

    Thank you for your response Don.

    I have CR 2013 running on Windows 7. I am able to open and generate the report. It crashes when I close the report.

    I tried the option that you mentioned , removing all sub reports and working on to remove a other parts of the reports. It still crashes. the report also has images. The report stops crashing after removing three images( tried this iteration by removing three random images everytime). Noticed that size of the report was reduced from 2.2 MB to 1.9 MB and stops crashing. However if I now try to add an image to the report it throws an error "Memory Full".

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.