C_BOCR_11 Exam Questions

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

Which two evaluation time functions can you use in a formula which contains a manual running total? (Choose two.)

You use two different ODBC DSNs that assign different data types (numeric in one data source and string in the second data source). Which three solutions can you use to link the di...

What is an acceptable file type for the imported XML transform?

Scheduling a report and sending sub-sets of data to different users dependent on the security is called:

You design a Crystal report for the Sales department. It lists customer orders received year-to- date and is grouped and subtotaled monthly by order date. It contains the selection...

Which three statements describe characteristics of a subreport? (Choose three.)

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?

You want to ensure that your Accounts Receivable listing report displays only those customers with invoices. Which join type must you specifies when you link the Customer and Invoi...

You create the following formula in a new Crystal report: Local NumberVar Array b; Redim b[10]; Local NumberVar i; For i := 1 To 10 Do ( b[i] := 7 * i ); What is the correct value...

You want to calculate summaries on a different dataset than the main report. The summaries must be calculated before the main report data is returned. These summaries must display...

What must you do when unmapped report fields appear in the Map Fields dialog box?

You want to design a weekly sales report that contains a list of all products sold during the week in the Report Header. Which type of array would you use to handle the data?

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

Which is the earliest evaluation time function you can use in a formula which does not use any database fields or summaries?

Your test report contains the following record selection formula: {Customer.Region} = "CA"OR DateTimeToDate ({Orders.Order Date}) > Date (2004,01,01) What is displayed when you sel...

Which two statements are true when you create a shared variable in a main report and pass the variable to an On-Demand subreport? (Choose two.)

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

In which pass do shared variables get processed?

Which two methods can you use to add tables to an existing report? (Choose two.)

Which two functions return a value based on the print state of the report being previewed? (Choose two.)

Which two pieces of information must you provide when you create a new connection to a Microsoft SQL Server database using an OLE DB connection in the Database Expert? (Choose two....

You must create a formula in a Crystal report to evaluate a sequence of commands many times rather than once. Which two control structures will allow you to do this? (Choose two.)

You create the following custom function in a new Crystal report: Function (TextVar Title); Select Title Case Mr. : Mister Case Mrs. : Missus Case Ms. : Miss Case Miss : Miss Case...

Which two situations would be appropriate uses of a dynamic array? (Choose two.)

What are three uses of a linked subreport? (Choose three.)

You must ensure that your Customer listing report displays all customers, whether or not they have an order. Which type of join must you specify when you link the Customer and Orde...

Which method should you use to create an ODBC connection to a Microsoft SQL Server database that is visible to all users on a specific computer?

Which two database characteristics can cause differences in the results of a query between a Crystal report and a third-party SQL tool? (Choose two.)

You create a Commission report for the Sales Manager. It is to be prepared at the end of each week and must list all active salespeople, whether or not they actually earned a commi...

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

Which two are advantages of using an ODBC connection to access data? (Choose two.)

In which three situations are Web Services beneficial? (Choose three.)

To connect to an XML data source, you must:

Which option of the Database Expert in Crystal Reports do you use to access a Data Source Name (DSN) for a Microsoft Access database?

You want to create a report that accesses a new database. No ODBC DSN for the database is listed in the available data sources. Which procedure must you follow to create the DSN?

You are creating a report and you open the Field Explorer. The field names are random alphanumeric values. Which database option should you enable to see an alternative to the fiel...

The field data type has changed from a string to a number in the database. In which situation will you have to manually update your report?

Which procedure should you use to determine whether Crystal Reports is the source of incorrect report results?

You create a variable in a subreport to pass back the following formula, called @SKUcalc, to the main report: WhilePrintingRecords; Numbervar SKU; SKU:=maximum(Part.PartID); In the...

You have been asked to create a sales report that will be scheduled and emailed to regional managers. You have decided to index saved data to improve report performance. Which of t...

How do you indicate the file type of the output file when using an XML transform?

You want to ensure that your Orphaned Invoice listing report displays only invoices that do not have valid Customer ID numbers. When you link the Customer and Invoice tables using...

You design a Crystal report for the sales department that is grouped by customer ID and order date and contains subtotals at both group levels. The Page Header contains the special...

You design a report with content that needs to be maintained by the HR department in a MS Word document that is updated daily. How can you dynamically incorporate that content into...

You must create a formula in a Crystal report that will evaluate an array, determine if the field value is already present in the array and add the value if it does not exist as an...

You have a report that contains an unlinked subreport. Which technique would you use to retrieve additional information on demand from within the subreport?

In a report you need to base a calculation on a shared variable passed from a subreport. Which two evaluation times could be used in the calculation? (Choose two.)

You are creating a new Crystal report using ODBC. What is the reason you do not see your database in the Select Datasource list?

What are three characteristics of a Full Outer Join? (Choose three.)