Bluekey Technical Test Level 3

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.

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.

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.

The Add Command is supported for the Oracle database type.

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.

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.

To create and display a simple report using Crystal Reports, you need to add both the CrystalReportSource and CrystalReportViewer controls to the project. The CrystalReportSource control is responsible for providing the report data to the CrystalReportViewer control, which then displays the report on the screen. Additionally, you may also need to add a reference to CrystalReports in order to access the necessary functionality and features of Crystal Reports.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.