You must use a formula in a new Crystal report that creates an account number for each customer. The account number consists of the first five alphabetical characters from the Customer Name field and the first five numeric characters from the Phone field. All records contain at least five characters of the correct type in each field. Which process would you use to create the account number?

Question

Accepted Answer

C. Create a formula with two While Do loops. The first extracts the first five alphabetical

Answer

A. Use If-Then-Else statements to return every possible result for each field. Create formulas to

Answer

B. Create a formula that uses a SELECT statement that is processed on the database server that

Answer

D. Use nested If-Then-Else statements to return every possible result for each field. Create a

You must use a formula in a new Crystal report that creates an account number for each customer. The account number consists of the first five alphabetical characters from the Customer Name field…

Question

Options

How the community answered

Community Discussion