Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Field margins shifting to the left on Crystal Report

Hi,

There is Crystal Report print issue on our web application.

I am working on production web server upgrade (from Windows Server 2003 to Windows 2008 R2). Our store order station (web application) calls web service to print pick slip, which contains customer and item information. We use Crystal Report as template for the pick slip.

After we brought the server into service at 7:00am EST, pick slip print worked fine until more stores (located in the western Canada) opened at 12:00pm EST. Almost all the data on pick slip shifted to the left about 10mm (depending the field width defined in Crystal Report), and those data exceeded left border of the fields did not get printed on the pick slip (please refer to the two attachments).

Once we restarted IIS, pick slip print worked again. As this is production box, we cannot leave it running and manually reset IIS frequently.  It sounds like there is load issue with Crystal Report runtime. Is Crystal runtime environment “Reset” when we restart IIS? 

1) Version of CR: CRRuntime_64bit_13_0_10

2) Version of VS: VS2010

3) OS: Windows Server 2008 R2

4) Version of IIS: IIS 7.5

Can you please help me out on this issue?

Thank you.

bad pick slip.jpg (156879 B)
good pick slip.jpg (169117 B)
Former Member
replied

HI Tony,

That's a new one. There are issues with right margins and text truncating but first time I've see a right margin issue.

It does sound like a resource issue though. IIS and .NET uses GDIPlus to render these objects so it could be an issue with that part.

Resetting IIS is actually recommended by Microsoft due to Memory Fragmentations, they can't defrag memory on the fly like UNIX OS's can.

Make sure you are using Report.Close and Dispose and you could through in GC.Collect to try to force Windows to release the memory. It won't fix the fragmentation issue though.

Crystal Requires Contiguous memory space, defragging with fix that but requires a reboot or cycling of IIS and/or the host app.

Don

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question