There are a number of threads on this subject. The problem is the Crystal Reports print engine and how it works with label printers.
The general fix I tend to go with is to redesign the reports to rotate fields 90 degrees (converting numeric fields to text first).
Another idea I've seen is to set a false label length in the report (so for a 4"x2" label, set it to be 4"x5" but with nothing below the 2" mark...), so the results are oriented the way you want, but CR "thinks" it is portrait.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------