C_BOCR_11 Exam Questions

Your HR Manager asks you to create an array of all 4000 employee IDs for your company. You create the following formula in a Crystal report: whileprintingrecords; numbervar array E...

You must create a custom function that converts centimeters to inches or vice versa depending on an argument passed to the function.Which custom function syntax is correct?

You must link two tables on an employee ID field in a Crystal report. The parent table's field is a string, but the child table's field is a number. How can you create a report tha...

You create the following custom function to convert Celsius to Fahrenheit or vice versa depending on an argument passed to the function: Function(): Global StringVar CurrentTempTyp...

Which of the following must you choose from the list of available data sources when connecting to XML data?

Which three report design tasks can you use with server-side grouping? (Choose three.)

Which two formulas are processed in the first pre-pass? (Choose two.)

Where is the transform information stored?

What are three uses of an unlinked subreport? (Choose three.)

You must create a report based on a Business View. How can you do this?

You create a sales report that requires quota data to be displayed. The quota and sales data are kept in different database types. Which method can you use to pass the quota data f...

You must use a formula in a new Crystal report that creates an account number for each customer. The account number consists of the first five alphabetical characters from the Cust...

Which type of subreport would you use to insert information into a report that is generated when a hyperlink is clicked?

You receive errors connecting to Web Services data in Crystal Reports 2008. Which two methods will help you identify the problem? (Choose two.)

Which method can you use to correct a problem in a WHERE clause?

What value is returned by UBound ( [ "Dog", "Cat", "Horse" ] )?

How do you create a report based on a Web Service in Crystal Reports 2008?

Which three are valid join types in Crystal Reports when using an ODBC connection to a PC-type database? (Choose three.)

You create a new Crystal report and group on the customer name. Which method would you use to create a subreport that displays the orders for each customer?

Which item should you select to view SQL statements generated by Crystal Reports?

Which two events occur during the second evaluation pass? (Choose two.)

How do you troubleshoot performance issues with Web Services in Crystal Reports 2008?

Which two statements are true limitations of the Crystal formula anguage? (Choose two.)

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.)

Which two checks can you perform with the Dependency Checker? (Choose two.)

You create a Crystal summary report that displays customer names and store locations. Group Footer #1 contains a summary of each customer's overall purchases last year and Group Fo...

You want to add a drillable Xcelsius chart to a report. Which method must you use?

What is the reason you are unable to edit a report that was created against an ODBC data source?

You want to use conditional formatting to link a dynamic image object, corporate_logo.jpg, to a Crystal report. Which format should you use for referencing the location of the grap...

You create a report showing annual sales grouped by customer name but want to display results for customers in North America only. Which two techniques can you use to achieve this...

Which three units of measure can you use to define the page size? (Choose three.)

What is the default file version when you save a report to crystalreports.com?

You have made a decision to use an existing report as the corporate template. You have been asked to create a sales report. Which two report objects will the template apply to the...

Which two export options can you use to display the correct Page N of M values in an exported file? (Choose two.)

What would cause Crystal Reports to refresh the report data?

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...

In which two sections of a report can you insert a Cross-Tab object? (Choose two.)

Which two methods can you use to create a new cross-tab in your report? (Choose two.)

Which data source does Crystal Reports 2008 automatically install?

A motorcycle manufacturer contracts you to produce a complex inventory report. The Production Manager informs you that the seventh character in each motorcycle's 12-character seria...

Which two statements are true regarding barcodes? (Choose two.)

Which two top-level data source folders can you choose if you want to create a new report using the Standard Report Creation Wizard? (Choose two.)

Which two formulas will return a string of 10 blank spaces? (Choose two.)

Which feature of Crystal Reports formulas must you use to perform a prescribed set of steps without specifying each step?

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 Cu...

You need to modify an existing calculated member in a Cross-Tab. Which three formulas can you edit? (Choose three.)

You are developing a Crystal report for a vehicle leasing company. All vehicle information is stored in an array, with each member of the array representing a different vehicle typ...

You want to connect to your Salesforce.com database for reporting. Which server will authenticate you?

You create a Crystal report that requires the company logo to appear on all pages after the title page. You want to use conditional suppression. Which formula will produce the corr...

Which formula can you use in a record selection to include all dates from the first day of the month to the date the report is refreshed?