SAP Certified Application Associate - Crystal Reports 2008

Question 1

You run a report and the report returns an error that fields are missing. Which feature can you use to determine if the database structure has changed?

A. Verify Database

B. Show SQL Query

C. Check Dependencies

D. Record Selection Formula

Correct Answer: A

Question 2

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?

A. System regional settings default value

B. Default value defined in the DSN

C. Database default NULL value

D. Crystal Reports default NULL value

Correct Answer: C

Question 3

How do you point an existing report to a new universe in Crystal Reports 2008?

A. Recreate the universe query.

B. Reset the data source location to the new universe.

C. Create a new report.

D. Update linking in report.

Correct Answer: B

Question 4

Which three If-Then-Else control structure formulas in Crystal syntax will generate an error? (Choose three.)

A. If {Orders.order Amount} < 1000 Then "Low" Else "High"

B. If {Orders.Order Amount} < 100 Then"Under $100"ElseIs {Orders.Order Amount} in 100 to 200 Then "Between $100 and $200"

C. If {Orders.Order Amount} < 200 ThenUnder $200 ElseIf {Orders.Order Amount} in 200 to 300 Then Between $200 and $300

D. If {Orders.Order Amount} < 100 Then formula = "Under $100" ElseIf {Orders.Order Amount} in 100 to 200 Then formula = "Between $100 and $200" EndIf

Correct Answer: B,C,D

Question 5

You insert a subreport into a sales report and link it at the country group level. Which two items are created when a subreport is linked to a main report? (Choose two.)

A. Country parameter field in the subreport

B. Record selection formula in the main report

C. Sales parameter field in the main report

D. Record selection formula in the subreport

Correct Answer: A,D

Question 6

You create a Crystal report containing basic employee contact information including an employee photo in a primary report. Occasionally your manager must view information on an employee's educational background, employment history or training. You decide to use On-Demand subreports to supply the additional data. Which action retrieves the data from the database?

A. Saving the report with data

B. Opening the main report the first time

C. Selecting the subreport design tab

D. Clicking the subreport hyperlink

Correct Answer: D

Question 7

Which option will you choose from the Group Select Expert to display the countries that generate the least orders?

A. Bottom N

B. Top N

C. No Sort

D. Descending

Correct Answer: A

Question 8

What are three Crystal Reports 2008 viewer features? (Choose three.)

A. Export to Microsoft PowerPoint

B. Docked/Stationary Toolbar

C. Java DHTML Viewer Exporting

D. Independent Group Tree Scrolling

Correct Answer: B,C,D

Question 9

Which menu will allow you to import a new XML transform?

A. Report Import Options

B. Manage XML Exporting Formats

C. Manage XML Importing Formats

D. Report Export Options

Correct Answer: B

Question 10

What is the reason you cannot insert a Group layout chart in the Page Header section?

A. A Group layout chart cannot be placed in the Page Header section.

B. You have not saved the report with data.

C. The Page Header section is suppressed.

D. You do not have access to the database.

Correct Answer: A

Question 11

The Sales department has a report listing the two sales channels, Direct and Indirect. There is a grand total for all sales at the end of the report. There is however also a requirement for a grand total for each channel.
Which method should you use to provide the total for each channel?

A. Create 2 running totals, evaluating on the relevant channel, and place them in the group footer.

B. Create 2 running totals, evaluating on the relevant channel, and place them in the group header.

C. Create 2 running totals, evaluating on the relevant channel, and place them in the report header.

D. Create 2 running totals, evaluating on the relevant channel, and place them in the report footer.

Correct Answer: D

SAP Certified Application Associate - Crystal Reports 2008 - C_BOCR_08 Exam Practice Test

Latest Update

Useful Links

Contact Us