Online Access Free C_BOCR_08 Practice Test

You design a report in Crystal Reports using three different groups. You notice that you inserted the first and second groups backwards: first by City, then by State and then by Customer. The correct sequence is State, then City and then Customer. Which two procedures can you use to correct this situation? (Choose two.)

• A.Open the Group Expert and use the black arrows in the upper required corner to reorder the groups as required.
• B.Delete the first two groups and recreate them in the correct order.
• C.In the Design view, click the Group Header #2 caption on the left side and drag it on top of the Group Header #1 caption. Release your mouse button and the groups will reverse sequence.
• D.Delete only the City group. Use the Insert Group icon to recreate the City group and move it between the State and Customer groups.

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

• A.Create a new report.
• B.Reset the data source location to the new universe.
• C.Update linking in report.
• D.Recreate the universe query.

Which two methods can you use to show the same data, grouped differently, in the same report? (Choose two.)

• A.Subreports
• B.Cross-Tab
• C.SQL Command
• D.Conditional Grouping

Your Sales Manager asks you to create a simple Crystal report listing all customers around the world in alphabetical order with no grouping. He wants total sales by country. You begin by creating running total fields to sum sales for each country. Which section should you place the running total fields in the report?

• A.Report Header
• B.Report Footer
• C.Page Footer
• D.Page Header

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 ({@Evaluate});
• B.GroupSum ({@Increment, 200000});
• C.GroupSum ({@Evaluate, 200000});
• D.EvaluateAfter ({@Increment});