Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there a limit to no. of fields CREATE REPORT can hand
Message
De
13/09/2002 12:21:57
 
 
À
13/09/2002 12:14:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00700223
Message ID:
00700230
Vues:
16
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform