Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Formula help
Message
From
13/11/2007 09:39:06
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
General information
Forum:
Crystal Reports
Category:
Formulas and functions
Title:
Environment versions
Crystal Reports:
Crystal Reports XI
Miscellaneous
Thread ID:
01268151
Message ID:
01268630
Views:
13
Just shows how big of a noob I am at Crystal Reports formulas - Thanks for the solution!

>don't you need a ; at the end of the first IF?
>
>
>>I am trying to create a formula to format a phone number and append an extension if it exists. Here is my formula:
>>
>>
>>stringVar result;
>>IF Length ({rptDealerSummaryReport.BusinessPhone}) = 10 Then
>>result := Mid ({rptDealerSummaryReport.BusinessPhone}, 1, 3) + "-" + Mid ({rptDealerSummaryReport.BusinessPhone}, 4, 3) + "-" + Mid ({rptDealerSummaryReport.BusinessPhone}, 8)
>>Else
>>result := {rptDealerSummaryReport.BusinessPhone}
>>
>>IF Length({rptDealerSummaryReport.BusinessExt}) > 0 Then
>>result := result + " x" + {rptDealerSummaryReport.BusinessExt}
>>
>>
>>I get this error before it hits the second IF statement: "The remaining text does not appear to be part of the formula."
>>
>>It's like it doesn't realize I want two separate IF statements. What am I doing wrong?
Very fitting: http://xkcd.com/386/
Previous
Reply
Map
View

Click here to load this message in the networking platform