Last post Dec 16, 2011 07:38 AM by thom4fun
Dec 16, 2011 04:01 AM|thom4fun|LINK
I look for help, after I use crystal reports for VS for what a lot of years. So, now I use VS2010 Ultimate to create also my web sites, which included crystal reports (.Net4). My problems start after I update an old site. The error I get: Report could not
be open. BUT: I get this error AFTER I open the report more than 50 times!
What I try: I let it run on windows 2003 server 32 Bit , Windows 2008 32 Bit and also 64 Bit. I hgher the stack size of w3wp.ex nothing helps.
Then I bild an easy report. less data, easy form less parameters, only on small picture. Get a form, use a crystal reportviewer, bind a dataset to the report and show it, with a button on the page in a new window, so that the report would be shown in ther
own web browser.
Then I use a mouse and keyboard recorder :) und open the report again and again.. (Of course, and close the window)
What you could see on the server is that the w3wp task use more and more memory. After round about 72 times the report would not be shown. Instead there is an error: Repord couldnt be loaded. The error comes if I bind the dataset to the report. (in other
cases I try to export the report to a file, also doesnt run, of course, because the error starts, if I try to bind the dataset, but the report viewer could not be the problem..)
The funny think is, that since this point is reachd it is not possible to open also each other report! Also each other report said: Could not be load!
Whats going on? is it a bug in crystal reports, or is it a new Limit from SAP????? The used memory could not be the reason. w3wp.exe use round about 500MB of mem, to higher the stack size chaged nothing. Do you have some ideas to work around, or maybe a
many thanks in advance
Dec 16, 2011 05:41 AM|shumailaAjk|LINK
visit this may this help you
Dec 16, 2011 07:38 AM|thom4fun|LINK
yes it helps! There is a mayor changing in the crystal report engine, which limits the amount of reports to 75!
I think also that there is a mayor bug, because to work around you have to dispose and gc collect manually each item you use with the report like reportviewer dataset etc etc,
So if you do so (dispose aand gc collect) you don't run in the 75 Reports Limit.
Nice links with more help:
Regarding Processlimit: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f053713e-3e3d-2c10-2a81-f79259e54023
Regarding Dispose: http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/f053713e-3e3d-2c10-2a81-f79259e54023?QuickLink=index&overridelayout=true
So, let me say many thanks for your help.