General information
Category:
Reports & Report designer
I only use the ALLTRIM(STR()) format when I know I'm dealing with integers. If I have decimals, I pass the extra parameters to STR() that specify the number of decimals. I'm kind of leary of switching to TRANSFORM() after reading the Knowledge Base article I mentioned previously. Did you take a look at that?
>>Is there any particular reason why you use TRANSFORM() instead of ALLTRIM(STR())? I just searched the MS Knowledge Base and found the following article that mentions some problems with TRANSFORM(): Q247494. I've just always used ALLTRIM(STR()), and never really looked at anything else, so I didn't know if there was a benefit to using TRANSFORM() other than less typing.
>
>One function instead of two, and also look to the difference between:
>lnNumber=2.345678901
>?transform(lnNumber)
>?alltrim(str(lnNumber))
>
>>>>There may be a better way, but of the top of my head:
>>>>
>>>>ALLTRIM(STR(VAL( LEFT( oJC.IssMonth, 2 ) )))
>>>
>>>Hi Jonathan,
>>>
>>>With VFP6.0 I make a habit to use transform() instead of alltrim(str())
>>>
>>>
>>>>>Hi everybody,
>>>>>
>>>>>I have this string in my report:
>>>>>SUBSTR(oJC.IssMonth,3) +' YEAR-TO-DATE RECAP THRU ISSUE ' +LEFT(oJC.IssMonth,2)
>>>>>
>>>>>left(oJC.IssMonth,2) would be '07', '08', etc. I would like to print just '7' or '8' in my Report. What would be the simplest way to achive this?
>>>>>
>>>>>Thanks.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only