HNS Crystal Report Quiz

In which of these report sections would you find a Grand Total summary field?

If my report's details are currently in no particular order, and I want them in ascending order<br>using a date field, which of these will work?<br>

What is the name of the feature that changes your report to include only the top 5 groups?

I want to know how many different customers made a purchase in the past month. What<br>summary function would I use:<br>

If I want each customer to have both a subtotal and a page break, I would need to have one of<br>these in my report:

Which item in the Database menu allows you to check/change the links between tables in the<br>report?<br>

You link the customers table to the orders table, which is a one-to-many relationship (one<br>customer to many orders). You insert two grand totals. One totals a field from the Orders table<br>and the other totals a field from the Customers table. Which grand total will be inflated?<br>

When you write a formula to combine or "concatenate" two text fields or text strings, which<br>of these symbols do you put between them?<br>

Which of these formula lines is correctly commented so it will be ignored when the report is<br>run? (The formula is using Crystal syntax.)<br>

Crystal Reports is part of the .net environment

Which version of Crystal Reports is officially compatible with XP?

What is the file type associated with a Crystal Report?

Which example will tell me the position of the first letter "X" in the field?

Which example will change a date value into a text value?

Which Crystal function can help you print [Continued] at the top of a page when a group<br>grows beyond one page?<br>

You are in the Section Expert and within the "suppress" property condition formula. Which<br>formula will suppress rows with an amount less than $50?<br>

Which pair of sections is most likely to contain an unlinked subreport:

By definition, a linked subreport will always have to contain:

If you were creating a running total formula using variables, what would this formula start<br>with:<br>

If all of the following are placed in the group footer, which will most likely slow down the<br>report the most:<br>

) I use the Group Sort Expert to select the Top 10 customers and don't check "include others".<br>What is the easiest way to get an accurate grand total of the Top 10:<br>

Which variable "scope" allows me to share a value from a subreport to the main report?

You have a subreport placed in a section. That section has the 'Hide' property checked. Will<br>that subreport run in the background?<br>

You have a formula placed in a section and that section needs to be either "Hidden" or<br>"Suppressed". Will the formula work the same in this section as it would in a visible section?<br>

If you open a report, and it opens in preview immediately, before you do anything, what does<br>that mean?<br>

If you can calculate the same value in a Crystal SQL Expression field as you can from a<br>Crystal formula field, which is usually the most efficient?<br>

) You insert Sales.rpt as a subreport into a container called Monthly.rpt. You need to give<br>Monthly.rpt to a user on another workstation. How many files do you need to move to that<br>workstation:<br>

Can I use "Insert Summary" to create a grand total of this formula?<br> Average ({Sales.Amount} , {Customer.Name}) * .15<br>

You created a report that doesn't use any linked tables. Instead it is based on a single SQL<br>query that was written within Crystal and is maintained within the Crystal. What are you using?<br>

I want to calculate how many days have passed since July 4, 2008. Which of these will give<br>me the correct answer?<br>