Crystal Reports Basic Knowledge Test
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
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
Back to top