Bluekey Technical Test Level 3
-
What do you need to add to a project in order to create and display a simple report using Crystal Reports?
-
CrystalReportSource control
-
CrystalReportViewer control
-
CrystalReportSource and CrystalReportViewer controls
-
CrystalReportViewer control and a reference to CrystalReports
-
The 'BLUEKEY TECHNICAL TEST LEVEL 3' assesses knowledge in creating and managing reports using Crystal Reports. It covers topics from basic control setup to advanced data sharing and subreport management, crucial for developers and IT professionals.
Quiz Preview
- 2.
A subreport that gets its parameter values from fields in the main report is a
-
Unlinked subreport
-
Linked subreport
Correct Answer
A. Linked subreportExplanation
A subreport that gets its parameter values from fields in the main report is referred to as a linked subreport. This means that the subreport is connected or linked to the main report, and it relies on the values from the main report's fields to populate its own parameters. This linkage allows for the subreport to dynamically adjust and display relevant data based on the values in the main report.Rate this question:
-
- 3.
On-demand subreports are or can be
-
Cannot open in their own preview tab
-
Parameters
-
Executed when the user does not click the hyperlink
-
Opened in-place in the report
Correct Answer
A. Opened in-place in the reportExplanation
On-demand subreports are opened in-place in the report, meaning that they are displayed within the main report itself rather than in a separate preview tab. This allows for a seamless integration of the subreport within the main report, providing relevant information to the user without the need to navigate away from the main report. Additionally, on-demand subreports are executed automatically when the main report is run, even if the user does not click on the hyperlink associated with the subreport.Rate this question:
-
- 4.
Which methods can be used to share data between a report and a subreport?
-
Selection Formulas
-
Global variables
-
Shared variables
-
Stored procedures
Correct Answer
A. Shared variablesExplanation
Shared variables can be used to share data between a report and a subreport. Shared variables are variables that can be accessed and modified by multiple sections or subreports within a report. The value assigned to a shared variable in one section or subreport can be accessed and used in another section or subreport. This allows for the sharing of data between different components of a report, enabling the subreport to access and display data from the main report.Rate this question:
-
- 5.
If Convert Other NULL Values to Default is checked, then
-
NULL string formulas will return blank.
-
NULL numeric database fields will display as zero.
-
NULL string database fields will display as blank.
Correct Answer
A. NULL string formulas will return blank.Explanation
If the "Convert Other NULL Values to Default" option is selected, it means that any NULL string formulas will be converted to blank. This means that if there is a formula that results in a NULL string value, it will be displayed as blank.Rate this question:
-
- 6.
A shared variable must be declared in the main report before it is used in a subreport.
-
True
-
False
Correct Answer
A. FalseExplanation
A shared variable does not need to be declared in the main report before it is used in a subreport. Shared variables are used to pass values between the main report and subreport, and they can be declared and used in either the main report or the subreport, as long as they have the same name and data type. Therefore, the answer is false.Rate this question:
-
- 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}
-
Zero
-
$1.50
-
NULL
-
An error
-
1
Correct Answer
A. NULLExplanation
The result of the formula is NULL because any arithmetic operation involving a NULL value will yield a NULL result. In this case, since the Quantity is NULL, multiplying it by the Price will result in a NULL value.Rate this question:
-
- 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?
-
75
-
50
-
NULL
-
An error
-
Zero
Correct Answer
A. 75Explanation
The average will be 75 because when calculating the average, the NULL value is not included in the calculation. Therefore, the average is calculated by adding the two non-NULL values (100 and 50) and dividing the sum by the number of non-NULL values, which is 2. This results in an average of 75.Rate this question:
-
- 9.
The Current Connections folder lists
-
Data sources used in the active report file
-
Data sources used in all open report files
-
Connected data sources for the active report file
-
Connected data sources for all open report files
-
All connected data sources
Correct Answer
A. All connected data sourcesExplanation
The Current Connections folder in this context refers to a feature or section in a software or application that displays information about the connected data sources. The correct answer states that it lists all connected data sources, indicating that it provides a comprehensive view of all the data sources that are currently connected to the active report file or all open report files. This means that it includes data sources used in the active report file, data sources used in all open report files, and any other connected data sources.Rate this question:
-
- 10.
The Add Command is supported for which of the following database types?
-
Oracle
-
DB2
-
Informix
-
Sybase
Correct Answer
A. OracleExplanation
The Add Command is supported for the Oracle database type.Rate this question:
-
- 11.
OLE DB is similar to ODBC except that
-
No database layer is required.
-
An OLE DB provider is required instead of an ODBC driver.
-
Crystal Reports does not supply OLE DB providers.
-
Crystal Reports does not supply ODBC drivers.
-
OLE DB only works against Microsoft databases.
Correct Answer
A. Crystal Reports does not supply ODBC drivers.Explanation
The correct answer is Crystal Reports does not supply ODBC drivers. This means that Crystal Reports does not provide the necessary drivers to connect to databases using the ODBC protocol. Instead, Crystal Reports requires the use of OLE DB providers to establish connections with databases. OLE DB is a data access technology that provides a consistent interface for accessing different types of data sources, including Microsoft databases.Rate this question:
-
- 12.
Which of the following cannot be used in a record selection formula that is passed to the server?
-
%Discount
-
@Discount
-
?Discount
-
IsNull
Correct Answer
A. @DiscountExplanation
The "@" symbol is used to refer to a variable in a record selection formula. Therefore, "@Discount" can be used in a record selection formula that is passed to the server.Rate this question:
-
- 13.
Which utility can be used to test ODBC connections and run queries?
-
SQLCon32
-
ODBC Trace
-
Dependency Walker
-
Modules
Correct Answer
A. SQLCon32Explanation
SQLCon32 is a utility that can be used to test ODBC connections and run queries. It is specifically designed for this purpose and provides a user-friendly interface to connect to ODBC data sources, test the connection, and execute SQL queries. It allows users to validate the ODBC configuration, troubleshoot any connection issues, and verify the correctness of SQL statements. SQLCon32 is a commonly used tool by database administrators and developers to ensure the smooth functioning of ODBC connections and query execution.Rate this question:
-
- 14.
You begin creating a report by adding a new _______ control to a project
-
CrystalReportSource
-
ReportDesigner
-
CrystalReportViewer
-
ReportForm
Correct Answer
A. CrystalReportSourceExplanation
To begin creating a report, you need to add a new CrystalReportSource control to your project. This control acts as a source for the Crystal Reports functionality and allows you to connect to data sources, define report layouts, and generate reports. By adding the CrystalReportSource control, you can then proceed to design and view the report using other tools and controls such as ReportDesigner or CrystalReportViewer. The ReportForm option is not a valid control for creating reports.Rate this question:
-
- 15.
The _______ pane in the Standard Report Creation Wizard allows database tables to be added to a report.
-
Available Data Sources
-
Available Field Sources
-
Available Group Sources
-
Available Select Sources
Correct Answer
A. Available Data SourcesExplanation
The "Available Data Sources" pane in the Standard Report Creation Wizard allows users to add database tables to a report. This pane provides a list of available data sources that can be selected and added to the report, allowing users to access and analyze data from different tables in their database. By choosing the appropriate data sources, users can include the necessary information in their report and generate meaningful insights.Rate this question:
-
- 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
-
Data
-
Fields
-
Group
-
Select
Correct Answer
A. FieldsExplanation
The page in the Standard Report Creation Wizard that allows you to select the fields that will display on the detail lines of the report is "Fields". This page provides the option to choose the specific data fields that you want to include in the report's detail lines, allowing you to customize the information displayed and tailor it to your needs.Rate this question:
-
- 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?
-
Array
-
Viewer
-
Enum
-
Provider
Correct Answer
A. EnumExplanation
To assist in the selection of a report and allow it to display on a second form, an enum (enumeration) needs to be set up. An enum is a data type that consists of a set of named values, making it easier to define and work with a set of related constants. In this case, the enum can be used to define and store the available reports, allowing the user to select one from a list. The selected report can then be passed to the second form for display.Rate this question:
-
- 18.
What page in the Standard Report Creation Wizard allows database fields from related tables to be linked?
-
Data
-
Fields
-
Link
-
Select
Correct Answer
A. LinkExplanation
The Link page in the Standard Report Creation Wizard allows database fields from related tables to be linked. This page allows the user to establish relationships between tables by selecting the appropriate fields to link. This is important in order to retrieve data from multiple tables and create meaningful reports that include data from related tables.Rate this question:
-
- 19.
What page in the Standard Report Creation Wizard allows you to choose the field on which to sort a report?
-
Data
-
Fields
-
Grouping
-
Select
Correct Answer
A. GroupingExplanation
The Grouping page in the Standard Report Creation Wizard allows you to choose the field on which to sort a report. This page allows you to group and organize the data in the report based on specific fields. By selecting the desired field on this page, you can sort the report based on that field, providing a clear and organized presentation of the data.Rate this question:
-
- 20.
To fill a dataset for a report, what do you need to include at the top of the file?
-
Imports CrystalDecisions.CrystalReports
-
CrystalDecisions.CrystalReports.Engine
-
Exports CrystalDecisions.CrystalReports.Engine
-
Imports CrystalDecisions.CrystalReports.Engine
Correct Answer
A. Imports CrystalDecisions.CrystalReports.EngineExplanation
To fill a dataset for a report, you need to include the "Imports CrystalDecisions.CrystalReports.Engine" statement at the top of the file. This statement allows you to access and use the functionality provided by the Crystal Reports Engine, which is necessary for filling the dataset with the required data. The other statements mentioned in the options are either incorrect or not relevant to the task of filling a dataset for a report.Rate this question:
-
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Sep 20, 2016Quiz Created by
Shreyashah03
Back to top