Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you set a report to print on 11 by 17 paper?
Message
From
26/09/2020 09:12:16
 
 
To
26/09/2020 08:37:41
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01676242
Message ID:
01676255
Views:
40
>>>>>>>Hi,
>>>>>>>
>>>>>>>A customers wants me to create a report that will print on 11 by 17 (inches) paper in landscape format. I don't seem to be able to find this in the designer.
>>>>>>>
>>>>>>>Can it be done? If yes, how?
>>>>>>>
>>>>>>>TIA
>>>>>>
>>>>>>Hi, Dmitry,
>>>>>>
>>>>>>Go to Settings in your Windows system, select a capable printer, choose printing preferences, add a custom paper of the size you need (I used a PDF printer, for that). The new size will be available in the page setup of the Report editor (you may choose portrait and landscape at your will).
>>>>>>
>>>>>>Required update: the above solution would apply if your customer could replicate exactly the identification of the new custom paper size.
>>>>>>
>>>>>>A more general solution is to fill (by hand or programmatically) the first "Expr" field of the report (opened as a table) with the following content:
>>>>>>
>>>>>>ORIENTATION=1
>>>>>>COLOR=2
>>>>>>PAPERLENGTH=4318
>>>>>>PAPERWIDTH=2794
>>>>>>
>>>>>
>>>>>Antonio,
>>>>>
>>>>>Thank you very much!
>>>>>
>>>>>Question, how did you determine that 4318 is 17" and 2794 is 11"?
>>>>
>>>>17'' = 43.18 cm, but the unit used in the report metrics is tenth of millimetre. Therefore, 4318.
>>>>
>>>>(I hope this is right...)
>>>António,
>>>I don't want to be the wise guy. Bur your assumption that the report is in milimeter is wrong, it depends on the setting, see screenprint attached,
>>>Stay healthy
>>>Koen
>>
>>Koen,
>>
>>I think that the settings you're referring to do not affect the content of the Expr field, but only the visual components of the report editor (like the ruler or the displaying of the object coordinates). Even when set to inches or pixels, the page metrics in the Expr field are still required to be expressed in tenths of millimeter. Aren't they?
>
>Antonio,
>I do think you are correct, however my Expr field does not show the same content as yours, in mine it has 'Papersize = 9' for A4, and since 11x17 inch or to be precise 11 17/24 x 16 13/24 inch = A3, user has to set to A3 (find the papersize id for A3), provided his printer can handle that.
>Stay healthy
>Koen

Sergey wrote an interesting article about this: https://www.berezniker.com/content/pages/visual-foxpro/enumerating-printer-forms
Previous
Reply
Map
View

Click here to load this message in the networking platform