Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why blank on the first line?
Message
 
 
To
05/12/2022 10:27:43
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01685430
Message ID:
01685434
Views:
42
>>Hi,
>>
>>I have a VFP 9 report. One of the columns is email address. The width of the column is not enough for some, very long, email addressed.
>>The column is set, in the VFP 9 Report designer as [x] Stretch with overflow. The format is Character and [x] Overlay and [x] Left are checked.
>>What happens is that if the email address is longer than the column width allows, the first/top line is blank. Then the email address appears, on two line (as it should be). Here is an example:
>>(Note that the email is not aligned properly here, in UT. I just do not know how to align it correctly. In real report the email appears under the heading EMAIL ADDRESS)
>>
>>EMPLOYEE                   EMPLOYEE NAME                        EMAIL ADDRESS
>>123ABC                        John Smith                                  
>>                                                                              john_smith@longcompa
>>                                                                              ny.com
>>
>>
>>What do I need to change for this column (Email Address) in the designer?
>>
>>TIA
>>
>>Update: I just noticed that some records with a long email address do appear correctly. That is, they do not have a blank on the first line. Rather the email address is horizontally aligned with the EMPLOYEE.
>>But some other records do look "messed up"
>
>Try with ltrim(email, 1, chr(13)+chr(9)+" "+chr(10)) in the email field. Just a hunch. I really suspect you have something that doesn't print but causes a new line before the actual first printable character in those addresses.

Your suggestion was helpful in this regard: I noticed that there was an empty space before the email address, in the email address field. I removed this empty space and now everything prints correctly.
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform