How to order in formula

[kyzina]

Hi,
I have a formula for phone numbers and it is displaying not in order on the page. Needs to be Office 1st;Home 2nd; Cell 3rd.
It is displaying in different order when run crystal report. Any suggestions? Thank you.

if
{EP_PHONE.EP_PH_TYPE}='Office'
then "Office" + ":" + " " + {EP_PHONE.EP_PH_NBR}
else
if {EP_PHONE.EP_PH_TYPE}='Home'
then "Home" + ":" + " " + {EP_PHONE.EP_PH_NBR}
else
if {EP_PHONE.EP_PH_TYPE}='Cell'
then "Cell" + ":" + " " + {EP_PHONE.EP_PH_NBR}
else
"Other" + ":" + " " + {EP_PHONE.EP_PH_NBR}

 

[BettyJ]

You can group by {EP_PHONE.EP_PH_TYPE}. Click on Options button in the bottom of the Group Expert. Under common tab, in the first drop down select [tt]EP_PHONE.EP_PH_TYPE[/tt] and in the second drop down select [tt]in specified order[/tt]. In the Specified Order tab, under Named Group, in the drop down select Office as first item, Home as second, Cell as third. and Other as fourth item. Click OK. Click OK. (You have to suppress the Group Header and Group Footer sections also).

Hope this helps.

 

[kyzina]

Thank you so much! It worked!