How can I print vertical text on a FoxPro report?

Question

I have a report where the information on the first page needs to run with a different orientation to the other pages (i.e. the 1st page will have text running vertically, and the remainder horizontally). The text needs to come from the database so I can't embed an image. Can anyone help? Thanks in advance.

Answer 1

An easy way is having two reports. That is report1.frx configured to print portrait and report2.frx configured to print landscape.

Another little bit harder way is using OLE programming to export results to Excel in two tabs, first will be setup to print in portrait orientation and second tab landscape using this command:
oExcel.ActiveSheet.PageSetup.Orientation = n
where n=1 is portrait, n=2 is landscape.

I'm not sure you can change orientation from portrait to landscape on runtime mode.

hope it helps you.