Does anyone know if there is a data set "size limit" for crystal reports ??
 Here is what is going on.  We run a series of DSO reports each period that carry 12 months of historical data.  they have been running fine until period-10

The size of the largest reoccurring DSO report that has run successfully is 29.6 mb.

I have tried running this report for period 10 both through Business Intelligence and through Crystal itself but it gives me the dreaded blank page which I have seen before. 

Does anyone know if this is a BW limitation ?? something in crystal itself ? Bi ??

If anyone has come across this problem of "size: before please let me know how you got around it.  I do not want to split up the reports if I do not have to.  thank you...

A.

can't say i've ever hit a limit...have printed thousands of pages.

I hear you KEV, working within the city, you would be surprised what newspapers want with open records requests. They want every little piece of information they can get, and then will go through and nit pick to find information that can validate their stories.

not only newspapers but special interest groups, they are big proponents of finding any and all dirt on government employees.

Health Department reports are usually very extensive since they have so many guidelines, newspapers just want EVERYTHING and pick out what looks the best for the next news story.


Edited by comatt1 - 27 Nov 2012 at 9:18am

So I have found out that the reason the reports were failing is because of the lack of Memory during the processing of the report itself.  4GB of memory and most reports were taking up 3.67 GB to process.  I assumed the process was timing out ( past 60 minutes) but as it turns out the reports were "breaking" because of lack of memory.  So my assumption is that if I can convince the IT department to upgrade their hardware the problem should go away.  Hopefully.....

Thanks kevlray...