Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Formatting to nearest Char & ellipsis
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01246437
Message ID:
01246468
Views:
24
Craig

Thanks for your reply's. I am really stumped since I am running the EXE on my development machine so environment is the same. Since this is a report where space is limited, I presented to management the possibility to print the Day names (and others as well) where we could have trailing '...' to indicate chopping off of words, letters etc. So I modified this report and put the EXE out there and management came back with the comment that it was not the desired results. So when I print it out in development, I indicated that is sure was what they wanted. Now it makes me look kind of like a fool and I was hoping that i would not have to go and change code to get the desired results.

Thanks again and nice to see you on line! Congrats on the new baby!



>No idea. I'd say that somehow the report is rendering differently and my only guess is that maybe the printer that is set as default when you are working with it in Visual FoxPro IDE is not the same as the printer for wherever you are running the exe. In any event the field length will need to have some of there width taken off to get the desired effect at runtime if this isn't a printer issue. Also, make sure that you aren't saving the printer environment information with the report and that the font that is being used for the fields exists on the box that the compiled version is being run on. That's all I can think of. Good Luck.
>
>>Report cursor has the full name of the week, I print the report in Developement and get the disired results, however when I compile into an exe and run, it does not trim and add the ellipsis.
>>
>>I can do as you indicate to get desired results, but was wondering why i get development vs exe runtime differences?
>>
>>
>>
>>>Are you using the expression...
>>>
>>>Left(cursorname.lcDayname,3) + "..."
>>>
>>>...in the report field? If not, give it a try.
>>>
>>>Also, be careful with your CDOW(ldDate) as lcDayName... unless CDOW() is returning a padded character then you will want to use...
>>>
>>>PADR(CDOW(ldDate),9," ") as lcDayName
>>>
>>>...this will keep Wednesday, Thursday and Saturday from potentially being truncated in the cursor result set.
>>>
>>>
>>>>in the cursor running the report, a character field is selected by "Select .... ,CDOW(ldDate) as lcDayName, ...etc."
>>>>
>>>> In the report, it is a text box with the format to nearest character and ellipsis and expression is cursorname.lcDayname
>>>>
>>>>>Ronald,
>>>>>please give the complete coding input and output you are using for this formatting.
>>>>>Regards,
>>>>>Koen
Previous
Reply
Map
View

Click here to load this message in the networking platform