>>>>>>>Hi,
>>>>>>>
>>>>>>>My Euro customers says a forms that my app prints needs to be "adjusted" to their paper size A4. I tried printing the same form to my printer, selecting the paper size A4 and I don't see a difference. Of course, my actual paper is 8.5" by 11".
>>>>>>>
>>>>>>>What do you suggest I need to do - or emulate - their "issue"? How do you deal with this, if you have Euro customers?
>>>>>>>
>>>>>>>TAI
>>>>>>
>>>>>>I create the reports in A4, to avoid that the report gets cutoff on the right side.
>>>>>>
>>>>>>When printing I look at the setting (in the program the user can chose A4 or Letter size), and the update the Expr field in the frx accordingly.
>>>>>>
>>>>>>The Expr field always looks like this in my reports:
>>>>>>ORIENTATION=0
>>>>>>PAPERSIZE=1
>>>>>>COLOR=2
>>>>>>
>>>>>>Then I update the Papersize before running the report:
>>>>>>
>>>>>>
>>>>>>LOCAL lcOrientation
>>>>>>lcOrientation = SUBSTR(Expr,13,1)
>>>>>>*
>>>>>>LOCAL lcExpression
>>>>>>*-- Set papersize and orientation.
>>>>>>TEXT TO lcExpression TEXTMERGE NOSHOW
>>>>>>ORIENTATION=<<lcOrientation>>
>>>>>>PAPERSIZE=<<ICASE(toPreviewform.PaperSize="A4",'9',UPPER(toPreviewform.PaperSize)="LEGAL",'5','1')>>
>>>>>>COLOR=2
>>>>>>ENDTEXT
>>>>>>*
>>>>>>REPLACE Expr WITH lcExpression
>>>>>>
>>>>>
>>>>>Thank you for your message.
>>>>>All reports are created for the paper size 8.11 x 11 (regular paper size in the US).
>>>>>Do I understand that I need to - for this one customer - at run time to update the the field EXPR in the FRX file?
>>>>
>>>>Yes, because I use the same reports for A4 and letter, I update the frx in runtime. for this I create a temporary version of the frx and use this for the reporting.
>>>>
>>>>STRTOFILE(FILETOSTR("MyReport.FRX"), FORCEPATH("MyReport.FRX", getEnv("temp")))
>>>>STRTOFILE(FILETOSTR("MyReport.FRT"), FORCEPATH("MyReport.FRT", getEnv("temp")))
>>>>USE (FORCEPATH("MyReport.FRX", getEnv("temp"))) alias TempReport IN 0
>>>>REPLACE Expr WITH m.lcExpression IN TempReport
>>>>USE IN TempReport
>>>>
>>>>and then running the report with this temporary version.
>>>>Report form (FORCEPATH("MyReport.FRT", getEnv("temp")))
>>>
>>>I understand. This will be a big job for me since my app has 100s of reports, in different modules and I will need to "fix" them all.
>>>Btw, I have a customer in Aruba (and I see that you are in Aruba) and they have never asked for reports to be printed to A4 size paper. I suppose I was lucky there.
>>>Thank you!
>>
>>You may be able to automate the conversion, depending if you design the reports to use all the printable area of the letter size width.
>>
>>Aruba uses mostly Letter size because they got used to adopt US standards. Only government offices use A4.
>>
>>The other islands use mostly A4.
>
>I will have to check the design of the reports; I have not done it in many years. I will probably tell the customer that either they pay for the "fixing" of all reports or I will do it, as the need arises.
>
>I was just in Aruba and the invoice they printed for me was on a 8.5x11 paper.
>Thank you.
Most printers you can also set that if they receive Letter size to automatically scale for A4. See screenshot of my printer settings.
Christian Isberner
Software Consultant