Sample Questions:

What are three uses of an unlinked sub report? (Choose three.)

Reduce report processing time

Coordinate data that cannot otherwise be linked

Present different views of the same data in a single report.

Combine unrelated reports into a single report.

You must create a report based on a Business View. How can you do this?

Select the Report Wizard from the Previous Connections list in the Database Expert.

Select the required Business View from the Repository list in the Database Expert Repository

Select the required Business View from the Create New Connection list in the Database Expert.

Select the Report Wizard from the Current Connections list in the Database Expert.

You create a sales report that requires quota data to be displayed. The quota and sales data are kept in different database types. Which method can you use to pass the quota data from a sub report to the main report?

Use a bidirectional formula.

Use a shared variable.

Use a global variable.

Use a reverse formula.

Which default value is used for NULL values in a report when you choose Convert Database NULL Values to Default from the Report Options area of the File menu?

Crystal Reports default NULL value

System regional settings default value

Database default NULL value

Default value defined in the DSN

Dynamic Recipient Data Providers support which of the following data types? (Choose three.)

String

Boolean

Date Time

Currency

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?

Use If-Then-Else statements to return every possible result for each field. Create formulas to extract the required characters from the Customer Name and Phone fields and assign the results to global variables. Use a third formula to concatenate the results and display the account number.

Create a formula that uses a SELECT statement that is processed on the database server that concatenates the first five alphabetical characters from the Customer Name field with the first five numerical characters from the Phone field. The last line displays the ten-character result.

Create a formula with two While Do loops. The first extracts the first five alphabetical characters from the Customer Name field and the second extracts the first five numerical characters from the Phone field and concatenates them to the five alphabetical characters. The last line displays the ten-character result.

Use nested If-Then-Else statements to return every possible result for each field. Create a formula to extract the required characters from the If-Then-Else results then display the concatenated data.