>How do you set CREATE REPORT (Quick Report) to print landscape?
>Some of my reports do not fit into a potrait mode.
>
>SELECT field1,field2,field3,field4,field5,field6,field7,field8,field9 FROM xtable INTO CURSOR xTemp
>CREATE REPORT xReport FROM xTemp width 150
>REPORT FORM xReport PREVIEW
>
>The above will chop off what it cannot fit into potrait mode.
>Can anybody help?
>Thank you all!
You can change orientation on the fly, if appropriate.
SELECT field1,field2,field3,field4,field5,field6,field7,field8,field9 FROM xtable INTO CURSOR xTemp
CREATE REPORT xReport FROM xTemp width 150
use xreport.frx in 0
replace xreport.expr with strtran(xreport.expr, "ORIENTATION=0", "ORIENTATION=1") IN xreport
USE in xreport
REPORT FORM xReport PREVIEW
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison