Bluekey Technical Test Level 3
.
- 1.What do you need to add to a project in order to create and display a simple report using Crystal Reports?
- A.
CrystalReportSource control
- B.
CrystalReportViewer control
- C.
CrystalReportSource and CrystalReportViewer controls
- D.
CrystalReportViewer control and a reference to CrystalReports
- 2.A subreport that gets its parameter values from fields in the main report is a
- A.
Unlinked subreport
- B.
Linked subreport
- 3.On-demand subreports are or can be
- A.
Cannot open in their own preview tab
- B.
Parameters
- C.
Executed when the user does not click the hyperlink
- D.
Opened in-place in the report
- 4.Which methods can be used to share data between a report and a subreport?
- A.
Selection Formulas
- B.
Global variables
- C.
Shared variables
- D.
Stored procedures
- 5.If Convert Other NULL Values to Default is checked, then
- A.
NULL string formulas will return blank.
- B.
NULL numeric database fields will display as zero.
- C.
NULL string database fields will display as blank.
- 6.A shared variable must be declared in the main report before it is used in a subreport.
- A.
True
- B.
False
- 7.What is the result of the following formula if Quantity is NULL, Price is $1.50, and all report options are at their defaults? {Quantity}*{Price}
- A.
Zero
- B.
$1.50
- C.
NULL
- D.
An error
- E.
1
- 8.There are three records in a report. The values of FieldA are 100, NULL, and 50. You insert a summary on FieldA and choose Average. What will the average be?
- A.
75
- B.
50
- C.
NULL
- D.
An error
- E.
Zero
- 9.The Current Connections folder lists
- A.
Data sources used in the active report file
- B.
Data sources used in all open report files
- C.
Connected data sources for the active report file
- D.
Connected data sources for all open report files
- E.
All connected data sources
- 10.The Add Command is supported for which of the following database types?
- A.
Oracle
- B.
DB2
- C.
Informix
- D.
Sybase
- 11.OLE DB is similar to ODBC except that
- A.
No database layer is required.
- B.
An OLE DB provider is required instead of an ODBC driver.
- C.
Crystal Reports does not supply OLE DB providers.
- D.
Crystal Reports does not supply ODBC drivers.
- E.
OLE DB only works against Microsoft databases.
- 12.Which of the following cannot be used in a record selection formula that is passed to the server?
- A.
%Discount
- B.
@Discount
- C.
?Discount
- D.
IsNull
- 13.Which utility can be used to test ODBC connections and run queries?
- A.
SQLCon32
- B.
ODBC Trace
- C.
Dependency Walker
- D.
Modules
- 14.You begin creating a report by adding a new _______ control to a project
- A.
CrystalReportSource
- B.
ReportDesigner
- C.
CrystalReportViewer
- D.
ReportForm
- 15.The _______ pane in the Standard Report Creation Wizard allows database tables to be added to a report.
- A.
Available Data Sources
- B.
Available Field Sources
- C.
Available Group Sources
- D.
Available Select Sources
- 16.What page in the Standard Report Creation Wizard allows you to select the fields that will display on the detail lines of the report
- A.
Data
- B.
Fields
- C.
Group
- D.
Select
- 17.What do you need to setup to assist in the selection of a report and to allow it to display on a second form?
- A.
Array
- B.
Viewer
- C.
Enum
- D.
Provider
- 18.What page in the Standard Report Creation Wizard allows database fields from related tables to be linked?
- A.
Data
- B.
Fields
- C.
Link
- D.
Select
- 19.What page in the Standard Report Creation Wizard allows you to choose the field on which to sort a report?
- A.
Data
- B.
Fields
- C.
Grouping
- D.
Select
- 20.To fill a dataset for a report, what do you need to include at the top of the file?
- A.
Imports CrystalDecisions.CrystalReports
- B.
CrystalDecisions.CrystalReports.Engine
- C.
Exports CrystalDecisions.CrystalReports.Engine
- D.
Imports CrystalDecisions.CrystalReports.Engine
Questions: 7 | Attempts: 8965 | Last updated: May 26, 2021
-
Sample QuestionThe tux paint main screen divided into _______ sections
Questions: 90 | Attempts: 8598 | Last updated: Sep 17, 2020
-
Sample QuestionYou can create names of Inputs and Outputs in the I/O Setup Window.
Questions: 20 | Attempts: 8423 | Last updated: Aug 19, 2020
-
Sample QuestionWho is Reporter IN JIRA
Back to top