>>>>>>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham