x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 74 subscribers
  • Views 1957 views
  • Users 0 members are here
Browse Forums
Announcements
106
topics
32
replies
General Discussion
6k
topics
18k
replies
BigLouie

Report Problems with Data Size

SOLVED
Posted By

When I run most reports I receive an error message that the report data is too big and to reduce the size by changing the criteria. However if I write the same report in Crystal from scratch and run it the data really is not that much, sometimes it is just two pages of data. How come SageCRM can't handle a report that is more than a page long?

  • 0
    verified answer

    Hi BigLouie,

    Report data in Sage CRM is pulled, and converted to the desired format, by the Tomcat Service. Apache Tomcat (or simply Tomcat, is an open source web server and servlet container developed by the Apache Software Foundation (ASF). There are some known limitations of how Tomcat handles data; one of them being unable to handle datasize over 1024 Mb. The workaround for this issue is to filter the reports in to smaller chunks, and merge in Excel.

    Check your settings under Administration, Email and Documents, Documents and Reports configuration. 

    The settings of interest here would be:

    Desktop Size Limitation (Default value: 2000 | Max value: 10000)
    Report generator maximum memory (Default value: 512 | Max value: 1024)

    Crystal Reports is no longer supported by Sage CRM as of the 7.2 release.

  • 0 in reply to TomasBlomqvist

    Tomas, thanks for the information. As a work around I have created a couple of reports in Crystal Reports based on a silent DSN and it runs pretty darn fast.

*Community Hub is the new name for Sage City