Skip to Content
avatar image
Former Member

Does crystal report support 4gb of data generation?

Requirement: Split pdf files into multiple pdf if size exceed 4 GB data

Before implementing this requirement , I would like to have technical clarification as,

  1. Does crystal report support to generate 4 GB report at a glance?

    If yes then

  2. Crystal report uses default temp folder of windows drive (C drive) while generating report and store report on D drive. Is there any way that I can generate report on D drive without uses default temp folder of windows drive (C drive) shown in below screen.
  3. As per my analysis, crystal report takes 2/3 hours to generate 350 MB size report with 6GB RAM.
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 31, 2017 at 06:31 PM

    1. Yes, a Crystal Report can potentially have 4GB plus of data.

    2. You might be able to use an environment variable to set a temp folder on the D drive that is specific to a service account or the user account that you're using to run Crystal. I'm not absolutely certain whether this will work though.

    3. This depends on a lot of factors - complexity of the query, how much data is being pulled through the network, whether filtering/sorting/grouping is happening on the database server or in memory. As Crystal runs out of RAM, it will start swapping to disk, so disk speed is also a factor. I have found that frequently the most efficient way to run a report is to use a Command (SQL Select statement) that uses a Where clause to do ALL of the data filtering (DO NOT use the Select Expert!) along with grouping and sorting. For more information about using commands, see this blog post:

    And finally, there is no way to get Crystal itself to automatically split up a PDF based on anything, including data/file size..


    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2017 at 04:44 PM

    WOW, so many people trying to use Crystal Reports to do a database dumps these past few weeks.....

    Crystal Reports is a REPORTING TOOL, it is not for database dumps or archiving. There are tools/ways on the DB Servers to export or dump data into flat files.

    What would anyone be able to use that much info into one file for.

    Dump your data into flat files and then use CR to filter on monthly or Quarterly or possibly Yearly chunks of data to filter on.

    With that amount of data it will depend on users PC resources, there are limits to the amount of one PC can access. CR is hardware and software dependent.

    Good luck


    Add comment
    10|10000 characters needed characters exceeded