Crystal Reports Basic Knowledge Test

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Mhanly

Mhanly

Community Contributor

Quizzes Created: 1 | Total Attempts: 119

Questions: 12 | Attempts: 120 | Updated: Mar 21, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

Create your own Quiz

Questions and Answers

1.

What is the purpose of a parameter field? Provide an example of a situation where one would be used.
2.

What is the purpose of a formula field? Provide an example of a situation where one would be used.
3.

List and explain the 3 types of variable scope available.
4.

Explain the differences between the report header/footer, group header/footer, and page header/footer. Provide examples of the type of information that would be displayed in each.
5.

Explain the difference between a linked and unlinked subreport
6.
Provide an example of syntax which will
1. Return the first 3 characters from a string field ‘Transaction.Description’
2. Convert a string field ‘Transaction.Amount’ to numeric field if the field contains a numeric value, otherwise return 0
3. Convert a string field ‘Client.Lastlist’ to a date. The string is formatted as YYYYMMDD.
4. Change the color of an amount field ‘Transaction.Amount’ to red if the number is negative using the property field, otherwise it should be black
5. Return ’0-30’, ’31-60’, ’60-90’, or ‘91+’ given a date field ‘Account.List’. The value returned should be the number of days between the ‘Account.List’ field and the last day of the previous month.
7.

What is the purpose of the database expert and select expert? What portions of an SQL query does each make?
8.
Using the account & transaction table provided, explain how you would produce a report displaying the sum total of transactions for all accounts.
1. The report should accept input from the user specifying the client code(s).
2. The report should display each account in the account table, regardless of if there are transactions for the account in the transaction table.
3. The report should be grouped by client code, and show subtotals for each client code.
4. The report should contain a count of each transaction type by client code.
9.

What would you do differently to display only accounts where there were corresponding transactions?
10.
Using the client and transaction table provided, explain how you would produce a report displaying a summary of transaction types for each client code.
1. The report should accept input from the user specifying the client code(s), and transaction date range to be summarized.
2. The report should display one line per client code, summing the CRJ and DBJ transaction types, and showing the average value for each transaction type.
11.

There is an existing report that does not use any linked tabled, but is based on a single SQL query written within Crystal. What area of Crystal does this SQL query exist in?
12.

Explain and provide syntax showing how you would create a running total formula using variables which encompasses the entire report.

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 21, 2023

Quiz Edited by
ProProfs Editorial Team
Jan 26, 2012

Quiz Created by
Mhanly

Crystal Reports Basic Knowledge Test

What is the purpose of a parameter field? Provide an example of a situation where one would be used.

What is the purpose of a formula field? Provide an example of a situation where one would be used.

List and explain the 3 types of variable scope available.

Explain the differences between the report header/footer, group header/footer, and page header/footer. Provide examples of the type of information that would be displayed in each.

Explain the difference between a linked and unlinked subreport

What is the purpose of the database expert and select expert? What portions of an SQL query does each make?

What would you do differently to display only accounts where there were corresponding transactions?

There is an existing report that does not use any linked tabled, but is based on a single SQL query written within Crystal. What area of Crystal does this SQL query exist in?

Explain and provide syntax showing how you would create a running total formula using variables which encompasses the entire report.