Workshop

The quiz questions and activities are provided for your further understanding of the current hour's topics.

Quiz

1:

What is the name of the expert used to filter data?

A1:

The expert used for filtering data is called the Select Expert.

2:

What is the difference between the record selection formula and the group selection formula?

A2:

The difference between the record and group selection formulas is on which data they operate. The record selection formula operates on the records and is used to filter out individual values. The group selection formula operates on group summaries and is used to filter out entire groups of data.

3:

Name three types of summary calculations besides Sum.

A3:

Some other summary calculations besides Sum are Average, Variance, Maximum, Minimum, Count, and Median.

Activities

To ensure that you are comfortable with the topics discussed in this hour, try to perform the following tasks:

  • Create a report on the Customer table that only shows customers from the United States and Canada.

  • Modify the preceding report to be sorted first by region and then by city.

  • Create a report on the Customer table that shows the top five countries' based on last year's sales value.



Sams Teach Yourself Crystal Reports 9 in 24 Hours
Sams Teach Yourself Crystal Reports 9 in 24 Hours
ISBN: B003D7JUVW
EAN: N/A
Year: 2005
Pages: 230

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net