Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a limit to no. of fields CREATE REPORT can hand
Message
From
13/09/2002 12:21:57
 
 
To
13/09/2002 12:14:41
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00700223
Message ID:
00700230
Views:
15
This message has been marked as the solution to the initial question of the thread.
Inge,

It is based on the width of the page, but you have to set that before you call CREATE REPORT. You can do this with a call to sys(1037) (see below), but unfortunately this requires user intervention. Another option is to set up another printer on the end-user machine, that has landscape mode as the default orientation. The printer does not have to actually exist, or be connected to the computer. Then, before you CREATE REPORT, you SET PRINTER TO NAME "landscapePrinter".

>My report (create with CREATE REPORT-Quick Report) prints with fields chopped off even with it printing landscape. Looks like there are still plenty of space left for it to print the rest of the fields (in landscape mode) but it does not print more fields than what a potrait mode can handle. Is this a limitation of CREATE REPORT or is a way around it?
>
>(code below):
SELECT field1,field2,field3,field4,field5,field6,field7,field8,field9 FROM xtable INTO CURSOR xTemp
=sys(1037)
CREATE REPORT xReport FROM xTemp width 150
>
Steve Gibson
Previous
Reply
Map
View

Click here to load this message in the networking platform