Crystal Reports Basic Knowledge Test

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Mhanly
M
Mhanly
Community Contributor
Quizzes Created: 1 | Total Attempts: 127
| Attempts: 127
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/12 Questions

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

Please wait...
About This Quiz

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.

Software Quizzes & Trivia

Quiz Preview

  • 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 (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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 26, 2012
    Quiz Created by
    Mhanly
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.