Crystal Reports Basic Knowledge Test
This Crystal Reports Basic Knowledge Test assesses understanding of dynamic reporting features such as parameter fields, formula fields, variable scopes, and report structures. It evaluates practical skills in creating effective, data-driven reports.
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
- Return the first 3 characters from a string field ‘Transaction.Description’
- Convert a string field ‘Transaction.Amount’ to numeric field if the field contains a numeric value, otherwise return 0
- Convert a string field ‘Client.Lastlist’ to a date. The string is formatted as YYYYMMDD.
- 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
- 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.
- The report should accept input from the user specifying the client code(s).
- The report should display each account in the account table, regardless of if there are transactions for the account in the transaction table.
- The report should be grouped by client code, and show subtotals for each client code.
- 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.
- The report should accept input from the user specifying the client code(s), and transaction date range to be summarized.
- 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, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 26, 2012Quiz Created by
Mhanly
Want to learn Appium? The foundational Appium Quiz
Want to learn Appium? The foundational Appium Quiz
Back to top