Free SAP C-BOCR-08 Exam Dumps Questions & Answers

You create the following formula in a new Crystal report to return random records based on the user's parameter input: WhilePrintingRecords; NumberVar array Rnd_Array; Redim Rnd_Array[{?Records Returned}]; NumberVar Seed; numbervar arryindex1; Numbervar arryindex2; While arryindex1 := 1 To {?Records Returned} Do( Seed := Int (Count ({Orders.Order ID})*RND()); if not(Seed in Rnd_Array) and arryindex2 < {?Records Returned} then ( arryindex2 := arryindex2 + 1; Rnd_Array[arryindex2] := Seed ) );
Rnd_Array[1]; You receive an error when saving the formula. Which loop type should you replace the existing loop with to resolve the error?

• A.Do While
• B.For Next
• C.For Do
• D.Do Until

You design a Summary report with the Suppress option selected instead of the Hide option. Which two types of information will be displayed when you double-click a summary figure on the report? (Choose two.)

• A.Detail Header information
• B.Group Footer information
• C.Group Header information
• D.Detail Footer information

Which two procedures must you follow when you use the Database Expert to create a report based on an SQL command? (Choose two.)

• A.Select ODBC, select stored procedures, click OK.
• B.Select Show SQL Query in the Database menu, edit the query, click OK.
• C.Select ODBC, select Datasource, click Add Command, input SQL expression, click OK.
• D.Select OLE DB, select Datasource, click Add Command, input SQL expression, click OK.

You want to create a hyperlink formula in a Crystal report that dynamically references the customer name. The link is a graphic in the Detail section. Which formula can you use to create the hyperlink?

• A."http://www." + {Customer.Customer Name} + ".com"
• B."http://www." + "Customer.Customer Name" + ".com"
• C."http://www." + CurrentFieldValue + ".com"
• D."http://www." + DefaultAttribute + ".com"

You create a group selection formula for your report but receive an error "This formula cannot be used because it must be evaluated later." What caused this error?

• A.You used arrays in the group selection formula.
• B.You referenced a formula using "WhilePrintingRecords" in the group selection formula.
• C.You used print-time functions in the group selection formula.
• D.You used shared variables in the group selection formula.