Online Access Free C-BOCR-08 Exam Questions

You make changes to the record selection criteria in a Crystal report. In which two circumstances should you choose the Refresh Data option rather than the Use Saved Data option? (Choose two.)

• A.When adding one or more selection criteria.
• B.When removing one or more existing selection criteria.
• C.When it is important to avoid time delays caused by network traffic during database server connects.
• D.When up-to-the-minute, current information must be displayed on the report.

Which action should you perform to update a report to reflect a change to the database structure?

• A.From the Database Menu, select Set Datasource Location.
• B.From the Report Menu, select Refresh Report Data.
• C.From the Report Menu, select Check Dependencies.
• D.From the Database Menu, select Verify Database.

You design a Crystal report for the Sales department. It lists customer orders received year-todate and is grouped and subtotaled monthly by order date. It contains the selection formula: Sum ({Orders.Order Amount}, {Orders.Order Date}, "monthly") > $200000. What is the highest stage of processing that this report requires?

• A.Pre-pass 3
• B.Pass 1
• C.Pass 3
• D.Pass 2
• E.Pre-pass 2

You create a Crystal report that shows customer names and locations. You use a linked sub report to display details of the orders placed so far this year by each customer. Each customer's total purchases for last year are calculated and stored in the main report and retrieved by the sub report. The sub report must calculate the percentage increase or decrease in orders received this year as compared to each customer's purchases made last year. Which formula should you use to accomplish this?

• A.currencyVar cLYS; (cLYS - Sum ({Orders.Order Amount}))/ Sum ({Orders.Order Amount});
• B.Shared currencyVar cLYS(Sum ({Orders.Order Amount}) ?cLYS)/ Sum ({Orders.Order Amount});
• C.Shared currencyVar cLYS; (Sum ({Orders.Order Amount}) ?cLYS)/cLYS;
• D.Global currencyVar cLYS(Sum ({Orders.Order Amount}) ?cLYS)/cLYS;

Crystal Reports developers can extend the functionality of Crystal Reports by using add-ins in the Report Designer. With the use of add-ins, what do report developers now have the ability to do? (Choose two.)

• A.Dynamically set page size
• B.Set database connections based on a parameter
• C.Add application specific toolbars
• D.Launch other applications