Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Formula help
Message
De
13/11/2007 09:39:06
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
 
Information générale
Forum:
Crystal Reports
Catégorie:
Formules et fonctions
Titre:
Versions des environnements
Crystal Reports:
Crystal Reports XI
Divers
Thread ID:
01268151
Message ID:
01268630
Vues:
14
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/
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform