SAP Certified Application Associate - Crystal Reports 2008

Question 1

You use the following conditional formatting formula to display a background color of yellow when the condition is met: IF {Table.Field Name} > 5000 THEN Yellow You want the background color to be white when the condition is not met. Which two lines can you add to the conditional formatting formula to achieve the requirement? (Choose two.)

A. ELSE Transparent

B. ELSE CurrentFieldValue

C. ELSE White

D. ELSE NoColor

Correct Answer: C,D

Question 2

How can you show the same data, grouped differently, in the same report?

A. Summarized fields

B. Conditional Grouping

C. Cross-Tab

D. Custom Formula

Correct Answer: C

Question 3

You create a new Crystal report and group the report by the customer name and then by country. The tables in your database have a one-to-many linking relationship. Because of the linking relationship, field values from the primary table are repeated for each new field value causing double counting in the lookup table.
Which two methods can you use to create accurate summaries? (Choose two.)

A. Create manual running totals.

B. Use Running Total Expert.

C. Use Dynamic Summarized Fields Expert.

D. Create conditional grouping formulas.

Correct Answer: A,B

Question 4

When using the Database Expert in Crystal Reports, which two methods can you use to move database tables from the Available Data Sources area to the Selected Tables list? (Choose two.)

A. Right-click the table name, select Move

B. Click the > arrow between the two areas

C. Click and drag the table name onto the Selected Tables list

D. Click the table name and choose Upload to Report

Correct Answer: B,C

Question 5

You create a Commission report for the Sales Manager. It is to be prepared at the end of each week and must list all active salespeople, whether or not they actually earned a commission for the week. You do not want negative commission amounts to be included in the report.
Which record selection formula should you use for the report?

A. {Employee.Commission} >= 0.00 AND ISNULL( {Employee.Commission}) AND {Employee.Week#} =35.00

B. (ISNULL( {Employee.Commission}) OR {Employee.Commission} >= 0.00 OR {Employee.Week#} =35.00

C. (ISNULL( {Employee.Commission}) OR {Employee.Commission} >= 0.00 AND {Employee.Week#} =35.00

D. {Employee.Commission} >= 0.00 AND {Employee.Week#} = 35.00

Correct Answer: C

Question 6

Your report contains two formulas that use the same global variable, nOverBudget. The first formula, @Increment, is located in a Group Footer and increments the variable by one if the group total exceeds 200,000. The second formula, @Display, is located in the Report Footer and displays the number of groups that have exceeded 200,000. Which function can you use in @Display to ensure that the second formula returns the correct total count?

A. EvaluateAfter ({@Increment});

B. EvaluateAfter ({@Evaluate});

C. GroupSum ({@Increment, 200000});

D. GroupSum ({@Evaluate, 200000});

Correct Answer: A

Question 7

You configure a database connection which you use regularly for your reports. In which folder should you save the connection to make it easy to access?

A. Repository

B. History

C. Favorites

D. Current Connections

Correct Answer: C

Question 8

You have a date parameter in a Crystal Reports 2008 report. You want to give users the ability to view the report date parameter online. Which parameter option should you use?

A. Show on Viewer Panel

B. Optional Prompt

C. Allow Custom Values

D. Editable

E. Allow Range Values

Correct Answer: A

Question 9

Which operator can you use in Crystal syntax to comment out a piece of code?

A. Comment (#)

B. Comment (')

C. Comment (//)

D. Comment (Rem)

Correct Answer: C

SAP Certified Application Associate - Crystal Reports 2008 - C-BOCR-08 Exam Practice Test

Latest Update

Useful Links

Contact Us