Symptom
How to increase XML file size when XML/XSD used as datasource in Crystal Reports
Environment
- Crystal Reports XIR2 SP5
- Windows XP SP3
Resolution
There is no limitation on XML file size if you are reporting off XML and XSD files stored in local.
On the other hand, if you are reporting off XML/XSD files with URL using a web application (for instance Java application), some settings are required:
1. From client machine where the report is generated, go to C:\Program Files\Business Objects\Common\3.5\java and locate CRConfig.XML file:
2. Modify CRConfig.XML file:
Default value:
<JVMMaxHeap>64000000</JVMMaxHeap>
<JVMMinHeap>32000000</JVMMinHeap>
3. Modify to the following values:
<JVMMaxHeap>512000000</JVMMaxHeap>
<JVMMinHeap>256000000</JVMMinHeap>
4. For Java application to display report from the client machine where the report is loaded, go to Start>AllPrograms>Tomcat>Tomcat Configuration:
5. From the ‘Java’ tab, add the following options in the ‘Java Options’ panel:
XX:MaxPermSize=256M
Xms256m
Xmx256M
6. Set the ‘Initial memory pool’ to 256
7. Set the ‘Maximum memory pool’ to 512
8. Stop and restart the Tomcat.
Keywords
XML file, File size , KBA , BI-RA-CR-DSL , Crystal Reports on C++ Data Semantic Layer (ClassicUniverse) , How To